I am in the process of designing a 3 sheet report and need to pull calculated information forward into my final page. I have not been successful in coming up with a valid formula. I have tried using = SheetName!CellAddress which is similar to Excel, = Sum(SheetName!CellAddress), and mixed and matched with brackets, apostrophes and a myriad of other known delimiters. I give up and can't find what I need in the manual or online help.

Can anybody please advise. Many thanks in advance.

Sandra

Hi Sandra,

Currently, the Adagio Financial Reporter does not support cell references from different tabs, which is different from Excel. This is why the formulas you were creating based on cells from a different tab were not working.

A workaround is to have everything on the same tab, but separate the different sections with page breaks.

I will certainly post this as a suggestion for our development group, for a future release, if it isn't already there.

Regards,