Hi Ryan,

The Adagio Financial Reporter deals with referencing a cell differently than Excel. This is why you are getting an error when the formula is the way Excel works.

You need to use the QuerySheet function to do this:

=QuerySheet("Sheet name","Cell") or =QuerySheet("Sheet2","A1")

Note that the cell reference "A1" is in double-quotes, which is the exception to the rule of cells not being in quotes. Therefore, it would be better to 'Name' the cell rather than using the reference, in case you expand/collapse the Income Statement and the Net Income is in a different cell.

In your case, find the Net Income cell from the Income Statement, right-click on it and choose 'Create Named Range'. On the screen that appears, replace 'NewName' with 'NetIncome' (without a space in between the words), click Add to save this, and Done to save the change. Then your formula on the balance sheet can be:

=QuerySheet("Sheet2","NetIncome")