Possibly a dumb question here:
We want to get the value of a cell that is on sheet 2 into a cell on sheet 1. We tried the calc that works in Excel (='Sheet 2'!A1), but is doesn't seem to work in the financial reporter. Can anyone advise the correct formula?

Thanks
Matt