Topic Options
#47290 - 09/18/15 11:55 AM Printing Expanded SmartSheets
MER Offline
Adagio Scholar

Registered: 02/09/07
Posts: 89
Loc: Ontario
I'm just about done revamping our Chart of Accounts, so I now have SmartSheets set up in the Financial Reporter for most departments. I have them all in a Statement Group. How can I print (or print to Excel) all the reports in the Statement Group on an expanded basis instead of a collapsed basis? When I print or print to excel the sheets all print condensed, even when they were last viewed expanded.
Thanks.

Top
#47292 - 09/18/15 11:59 AM Re: Printing Expanded SmartSheets [Re: MER]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
Hi EMB,

On each statement group report, there is a checkbox to select whether you want to print that particular report either Expanded or Collapsed. You just need to choose the Expanded option. Most of the toolbar button properties can be set individually for reports, as options at the lower-right of the Edit Statement Group Item screen.
_________________________
Regards,
Softrak Tech Support

Top
#47293 - 09/18/15 12:04 PM Re: Printing Expanded SmartSheets [Re: MER]
Ken A. Offline
Adagio Maestro

Registered: 09/14/01
Posts: 1009
Loc: Kamloops, BC
Hello,

Edit each report in the statement group by right clicking on the report in the Statement group window and ensure that the "Expand Smartsheet" check box is selected on each report you want printed in expanded mode.

Please see the following picture below:

[img]https://www.dropbox.com/s/ipswx49wgvnutgp/Statement%20group%20settings.png?dl=0[/img]
_________________________
Thanks,

Ken Aberdeen,CPA, CMA
Aberdeen Business Consulting Ltd.
ken@aberdeenconsulting.ca

Top
#47295 - 09/18/15 12:41 PM Re: Printing Expanded SmartSheets [Re: Ken A.]
MER Offline
Adagio Scholar

Registered: 02/09/07
Posts: 89
Loc: Ontario
Great, thank you, I knew it was easy!
On a related note, the current 22 individual worksheets in the Excel workbook are named 'Sheet-Consolidated Departments' to 'Sheet-Consolidated Departments-(21)'. Is there a way to specify a name for each of the worksheets so when they export to Excel they will mean something to me and the Managers I distribute the F-S to?
Mari

Top
#47297 - 09/18/15 12:51 PM Re: Printing Expanded SmartSheets [Re: MER]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
The workbook is given the name of the Statement Group. The sheets within the workbook are given the name of the statement, modified by the department number if they are being printed for a single department (or department group).

If you have a suggestion for a different naming strategy, we'd love to hear it!
_________________________
Andrew Bates

Top
#47299 - 09/18/15 01:05 PM Re: Printing Expanded SmartSheets [Re: Retired_Guy]
MER Offline
Adagio Scholar

Registered: 02/09/07
Posts: 89
Loc: Ontario
I don't quite follow - "The sheets within the workbook are given the name of the statement". The Statement Group is F16 Financial Statements, and that's the name of the Excel spreadsheet, so I follow that. The statements included in the Statement Group though are saved as, for example, 'GL!SS-CFDC Operating.DAT', and 'GL!SS-CFDC Inv Fund.DAT'. Should the sheets within the Excel workbook not then be called 'GL!SS-CFDC Operating' etc, rather than 'Sheet-Consolidated Departments(21)'? Where does the wording 'Sheet-Consolidated Departments(#)' come from? I'm sure it's simple but I just can't see it. With respect to a naming strategy, it would be very user friendly to have the individual sheets named as the name of the statement. That's what I understand your reply above to say, though, which is why I'm not following. If that were the case I would save the statements as for example 'CFDC Operating', not 'GL!SS-CFDC Operating', and then I could easily find the sheet for CFDC Operations when I am scrolling through the worksheets in my 22 worksheet workbook.
I appreciate your help, thank you!
Mari

Top
#47301 - 09/18/15 02:37 PM Re: Printing Expanded SmartSheets [Re: MER]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
Hi EMB,

When exporting a financial statement to Excel, the sheet names in the created Excel workbook come from a combination of the respective sheet name in the Adagio financial statement and the department number selected for the report. The name of the Excel file is the same as the statement group. The individual financial statement file name is not used.

There is a maximum number of characters for the sheet names in Excel. The results you are getting mostly having to do with the fact that the Consolidated Departments text is taking up most of them, and to keep sheet names unique, they are getting suffixed with 1, 2, 3, etc. And the first part having Sheet likely has to do with your financial statement sheet name being Sheet 1 rather than something such as Income Stmt or Bal Sheet.

The first tip would be to change the text for a consolidated department selection to something shorter, which can be done from View / Customize. This would decrease the amount of characters used on the tab name for this, allowing more room for other info. Note that this text may print at the top of statements, so whatever you change this to should also be meaningful.

Secondly, you should rename tabs in your financial statements from Sheet X to something short but also descriptive and meaningful.

Note that if you rename a sheet in a financial statement, that will remove it's selection from statement group items, so you would have to go back and edit the statement group item to re-select the sheet. Not doing that causes that statement to be skipped when exporting, and for me actually crashed the Financial Reporter.
_________________________
Regards,
Softrak Tech Support

Top
#47302 - 09/18/15 02:38 PM Re: Printing Expanded SmartSheets [Re: MER]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Here is statement group from the sample data that creates a Workbook called "StatementSet1" and has the sheets named according to the names of the statements in the group. If the statement is generated "Consolidated" then that text is appended to the name, otherwise the department number is appended:
_________________________
Andrew Bates

Top
#47313 - 09/21/15 08:18 AM Re: Printing Expanded SmartSheets [Re: Retired_Guy]
MER Offline
Adagio Scholar

Registered: 02/09/07
Posts: 89
Loc: Ontario
Thank you. I will post if I have further questions.

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 82 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14459 Topics
70635 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