Topic Options
#42513 - 07/25/14 09:26 AM expand vs collapse smartsheet variable
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 186
Loc: Victoria, BC Canada
Hi Gang!
Is there a variable in Financial Reporter that I can grab to identify if the current 'look' of the report is expanded vs collapsed? What I'd like to do is identify the report as Report X - SUMMARY or Report X - DETAIL depending on if it happens to be expanded or not at the time of printing.
Thanks!

Top
#42519 - 07/25/14 10:12 AM Re: expand vs collapse smartsheet variable [Re: Hugh]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
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

Top
#42521 - 07/25/14 10:48 AM Re: expand vs collapse smartsheet variable [Re: Softrak Support]
Hugh Offline
Adagio Maven

Registered: 09/25/13
Posts: 186
Loc: Victoria, BC Canada
Damn! you guys are goooood! Thanks!

Top


Moderator:  Softrak Support 
Who's Online
1 registered (1 invisible), 52 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30