Summary Reports from Sheets in a Folder
Hello -
Quick question on summary reports for easier roll up than cell linking.
Background: Each time we have a new project, we create a folder from a template folder that contains a schedule and a budget tracker. Projects are all tracked the same.
Both sheets have Summary fields that are set up, so it can roll into a summary report.
is it possible for these sheets to all appear on one row, so all project metrics are shown in a neat row and always updated?
Apologies if this question isn’t clear.
Thank you!
Answers
-
Are you able to provide some screenshots for context?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Yes - please find below.
Essentially - all 3 of those sheets are in one Project folder, so it would be nice if these could roll into one summary row with all of the information. Every project would have the same setup and all of these columns.
In theory - I could create a roll-up sheet in each project folder and pull a summary report from that information, but it would still link all of the sheets in the folder unless manually deleted.
Just trying to keep this reporting process easier as projects are added. Hopefully this (somewhat) makes sense.
Thanks!
-
I would suggest the rollup sheet. When you save as new on the template folder, it will link to the newly created sheets.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!