Hi Hugh,
If you are running a reasonably current version of Adagio Ledger, there is a formula =IsExpanded("sheet name") that returns True if the smartsheet is expanded, and False if collapsed. You have to include the name of the sheet tab as part of this formula, in double quotes. So you could create a formula to generate different report titles depending on whether the sheet is expanded or collapsed, as in this example for a statement where the sheet name is 'Income':
=IF(ISEXPANDED("Income"),"Income Statement Detailed","Income Statement Summary")
_________________________
Regards,
Softrak Tech Support