Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Page Layout with a table and summaries
Smartsheet often shows a nice calculation at the top of a sheet. Say a list of dealers. The first five lines of the sheet have a nice summary box with the number of dealer in each state calculated or soemthing like that.
Now the sheet column headers are really matching the data table not the summary table. So name, address, state.....
If you do the summary table in those first few lines, then someone does a sort on the date table by the only way they can soting the column at the header, then the summary table gets messed up.
I don't get how to layout a sheet so one can do summaries and not have them get messed up if a user wants to do the logical thing like sort.
Some say do reports - but the reports are still pulling the summaries from a calculation that has to be located somewhere - where so as not to stop the full function of the sheet and data is the questions.
Ideas or examples?
Comments
-
A report is the best answer for this, as someone can sort the report directly and it won't affect the structure of the source sheets. You can also make some changes to the report directly without having to go into the source sheets. Check out the Help Center for more information on creating reports: https://help.smartsheet.com/articles/522214-creating-reports
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives