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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives