Status Update - Current and Previous
I have a dashboard that I'm working on and have two different updates I want to display.
- The lastest status update from a worksheet
- The previous update prior to the latest
I'm not certain how I can pull this information. I had used a metric widget but maybe that isn't the correct method.
Answers
-
You would have to store the previous update somewhere. Are you keeping it in another column, or is that the part you are needing help with?
-
I have all updates occuring in a status update sheet.
But I'm trying to automate this so I do have to keep manually fixing this each time I make an update:
-
Hey guys, to make this easy to explain, I recorded a quick video on one way to get it done.
@CLieberg you're going to need another sheet to capture the "current" value which then becomes the "previous" value when it's updated.
Build an automation on your current sheet to copy the row to a "history" sheet.
Then have that history sheet calculate the previously updated date. Point your dashboard widget to that history sheet.
Let me know if that helps.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K 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
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives