Metric sheets: using rows or using columns
I have set up a number of metric sheets using rows and columns to set out the data. Whilst the two approaches work separately and can work together in the same sheet has anyone developed any rules or principles about how to set up a metric sheet. I'm particularly interested where the sheet requires that you add new sheet (project) rows or columns to the metric sheet and whether this might means you use columns or rows.
Best Answer
-
The challenge with that is between the metrics themselves, how you want them displayed, and the source data, there are a TON of variables.
And now with the added features of reports with grouping and summary, metrics sheets are even less necessary.
Answers
-
The biggest determining factor is how you plan to leverage the metrics. If you want them displayed a specific way in a chart then you may need to have them structured a certain way whereas displaying them differently would require a different structure.
I usually end up with both eventually just to get the reporting I want.
-
Thanks @Paul Newcome .
Given the importance of metric sheets I think it time that Smartsheet developed some resources for users about metric sheets. This might include basic approaches to designing a metric sheet. Even some dos and donts or things to consider like what you alluded to. Thoughts?
-
The challenge with that is between the metrics themselves, how you want them displayed, and the source data, there are a TON of variables.
And now with the added features of reports with grouping and summary, metrics sheets are even less necessary.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives