Advanced linkage options

You can further customize your Connector linkages by applying advanced linkage options as described in the following examples.

To append text to values:

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

The cell displays the text appended to the value. Our example appears as Deferred financing costs, net of accumulated amortization of XYZ, where XYZ is the balance of account 350.

To add multiple account balances:

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

The cell displays the sum of the account balances. Our example shows the added balances of accounts 5000, 5001, 5004, 5005, 5006, 5007, and 5008 in the cell.