Hi Carol,

You have found the reason for not referring directly to a cell with the QuerySheet function, as when the SmartSheet is collapsed or expanded, the cell you want to display on a different sheet is now in a different place.

What you need to do is 'name' the cell that you want to appear in the QuerySheet formula, instead of using a cell reference. To do this, go to the sheet and cell that you want to appear on a different sheet. Right-click on that cell and choose 'Create Named Range'. On the screen that appears, replace 'NewName' with a meaningful name for that cell, such as Balance or SalesRevenue or ExpensesTotal or whatever. Don't have spaces in the name. Click the Add button to add it to the list, then click Done to save everthing and close.

Then in the QuerySheet formula on the other sheet, use this name instead of a cell reference. So your formula might look like: =QuerySheet("Company A Income Statement","TotalRevenue")

Note that you cannot create a name for cells that appear on Generated rows. This is because Generated rows are deleted when a sheet is collapsed. This only works for cells on rows that are not generated. Should you require values from generated rows (detail rows on expanding) on another sheet, you cannot use the QuerySheet process for doing this, and will need to create your financial statement in a different way. If this is the case, you may be better served contacting your Adagio consultant for assistance.