Advanced Linkage Options

Advanced linkage procedures available in Connector.

Appending text to values

1. Create a link to the value you want to display. Example: =cw_act("BR","350").
2. Include the desired text between quotes as well as &TEXT to the formula. Enclose the function within parenthesis. Example: ="Deferred financing costs, net of accumulated amortization of "&TEXT(cw_act("BR","350"),"$#,##0_);$(#,##0)").
3. Press Enter.

Results

The cell displays the text appended to the value. Example: Deferred financing costs, net of accumulated amortization of XYZ, where XYZ is the balance of account 350.

Adding multiple account balances

1. Create a link to an account balance. Example: =cw_act("BR","5000").
2. Use :: to add individual account balances and a ~ to add a range of account balances. Example: =cw_act("BR","5000::5001::5004~5008").
3. Press Enter.

Results

The cell displays the sum of the account balances. Example: The balances of accounts 5000, 5001, 5004, 5005, 5006, 5007, and 5008 are added and displayed in the cell.