Sheet setup for scalable data
Looking for a best practice to set up a scalable (target vs. actual, month-over-month) sheet - There are 15 specific varying metrics (e.g. numbers, $, %) collected monthly by different people. Each metric will require both actuals for the prior month and a target for the next month. I would like to show both monthly metrics and trends over time. Any suggestions on the best way to set up the sheet(s) so that I can easily create reports & show in a dashboard?
Answers
-
You could set up a second sheet with a copy row automation on the first to copy rows to the second on a recurring basis. This will give you those static metrics for historical data that can be used for trending and whatnot.
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!
-
Thanks Paul. I though about that, but how would that be different than creating reports from just the first sheet, besides keeping the first sheet clean (e.g. w/out prior data)? I also thought about creating a different sheet for each metric, but that would be a lot of sheets.
-
The reports will not capture historical data which means you won't be able to show trends.
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!
-
Can you suggest how I would make that work? I have an intake form for the data, it populates into the intake sheet, then automatically moves to the bottom of a different "summary" sheet. Would it be best if there was a unique summary sheet for each metric or ? Trying to figure out how I can best capture month over month data.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives