Status Update - Current and Previous

CLieberg

I have a dashboard that I'm working on and have two different updates I want to display.

1. The lastest status update from a worksheet
2. 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.

Paul Newcome

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?

CLieberg

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:

Ryan Sides

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.

https://youtu.be/g2haXL1_rQ4

Let me know if that helps.