How to add a time stamp when a status is changed?

VanessaRivera01

In the Sheet change there's a Record the date when specified criteria are met and is there one for Time? Or is there a formula to capture when specified criteria are met the adds a time stamp?

AravindGP

Hi @VanessaRivera01

You can use the Modified Date column in your sheet. It will capture the date and time of any modification to the row. The only downside is that it will keep on updating whenever there are changes to the row

SSFeatures

Hi Vanessa,

I recommend trying the solution from this thread. The solution is to use a helper sheet. When the criteria is met, you'll use automation to copy the row over to another sheet, and this other sheet will have the "Modified" column which includes the date and the time.

Then you'll update your main sheet to reference the modified column from this other sheet.

Best!

Andrée Starå

https://community.smartsheet.com/discussion/131281/how-to-add-a-time-stamp-when-a-status-is-changed

Hi,

I hope you're well and safe!

Please look at my post below, which contains a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Paul Newcome

@VanessaRivera01 Take a look a this method that I developed to capture date / time stamp data as static data based on a specific action. Once the below is set up, you would use an INDEX/MATCH to pull the date / time stamp back over to your working sheet.

https://community.smartsheet.com/discussion/63561/date-time-stamp-option