Metric Sheet Automation
Hello there,
Thanks in advance for the help.
I have a lot of data sheets that I want to summarize in one metric sheet. The data will be grouped based on the "assigned to" column.
Right now, if I add a new line to one of these sheets, I have to go into the metric sheet to manually add in a row under that appropriate "assigned to" person.
Is there a way to automate that so if I add a line to the data sheet, it'll automatically add it to the appropriate assigned to person in the metric sheet? I would like to not use the report functionality.
Thanks!
Best,
Anna
Answers
-
Hey @aly1234
How is your metric sheet set up? When I think of metrics sheets, I usually think formulas with counts & sums. However, it sounds like you're creating a report sheet as a stand in for the report functionality. Is this correct?
-
Hi Ro,
Correct. I would love to use formulas to pull the data but right now, yes I'm just using reference cell function as I'm not sure how to accurately do this.
Thanks!
Best,
Anna
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!