Capture metric each day and add to new row
I have a number of Harvey ball metrics (count of red, yellow, green tasks) and things that change every day. I haven't really seen any way to capture and store these each day at a particular time (or hourly, weekly, monthly). Anyone have a good solution for it?
Example of metrics I'm collecting on-the-fly from Control Center summary sheets... would love to be able to graph the health over time.. day by day.
Best Answer
-
The only way currently to convert a cell with a formula to a static cell is the copy/move workflows. You can set up a sheet to receive these, create a column that forces a change every day in the rows you want transferred even if there isn't a change in the data (example would be a =today() formula dragged down) and use that as criteria for the workflow.
Then base your charts off the historical data sheet.
Answers
-
The only way currently to convert a cell with a formula to a static cell is the copy/move workflows. You can set up a sheet to receive these, create a column that forces a change every day in the rows you want transferred even if there isn't a change in the data (example would be a =today() formula dragged down) and use that as criteria for the workflow.
Then base your charts off the historical data sheet.
-
I had completely forgotten about that workflow! Thanks!
Built the sheet that captures the data each day, made a couple reports to look at different ranges of time... and added some sample data to make sure it displays what I need.. perfect :)
-
NP Glad it worked for you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!