SmartSheets in the Adagio Ledger Financial Reporter typically have to be set up a certain way to function correctly. In any row, the contents of column A will usually contain the text '.Range', column B will have the account range, column C will have the account desctiption, and the remaining columns will have the amounts. This is the way the report is structured if you create it from scratch by dragging/dropping account groups from the View Account Groups window. There are also a few sample specs in the sample data to give you an idea of what a completed report will look like (for example, GL!IncomeStatement.sam).

The standard syntax for an account range is A:B-`. A is the first account, B is the last account, and the backwards apostrophe is the department replacement code. On the toolbar, there is a globe icon that allows you to toggle between Consolidated and Departmental mode. In the latter case, a drop-down field allows to to select an individual department or any department ranges you have created within the View Departments window. You could create the department range 300-399 there if you wish, then select it from the drop-down field.

You can also 'hard-code' the entire account range, in exactly the same way you did in your posting (5000:5999-300:399).

With SmartSheets, you have the ability of 'Expanding' or 'Collapsing' the sheet. Expand means showing the account details, and Collapse means showing only the consolidated amounts. Probably you are in Expand mode; to collapse, click the icon on the toolbar with the arrow pointing up. This will then show the summary value you want.

Regards,