Is there a formula that can capture the date when a cell changes?

Max Corbin

I have a list of dropdown categories to capture the project stage and would like to capture the date when the project stage changes. I also have a list of dropdown categories with the project stage owners that I would like to capture the date of when this changes. My goal is to see how long the project takes on each stage and in who's ownership the stages are. Is there a formula available where I can capture this information?

Mike Wilday

Not yet. But a said formula was announced during Engage 2021. It hasn't seen the light of day yet.

https://app.smartsheet.com/b/publish?EQBCT=84aea43be70e4c1693e76a42ffc5db88&_ga=2.129808076.1554807442.1605542939-1074882870.1602114816

The coming soon section of this published dashboard shows JAN 2021 as the expected release date.

Although the updates that were due in October still haven't been released either.

Mike Wilday

Yes!!! Its an automation!

https://www.smartsheet.com/content-center/product-news/release-notes/new-automated-action-record-date

You might need to set up several conditions if you're trying to record each stage change, but this automation will store a date in a column of your choosing based on a certain cell changing!!!

Mike Wilday

Not yet. But a said formula was announced during Engage 2021. It hasn't seen the light of day yet.

https://app.smartsheet.com/b/publish?EQBCT=84aea43be70e4c1693e76a42ffc5db88&_ga=2.129808076.1554807442.1605542939-1074882870.1602114816

The coming soon section of this published dashboard shows JAN 2021 as the expected release date.

Although the updates that were due in October still haven't been released either.

Andrée Starå

Hi @Max Corbin

Until the new feature is released you could use a workaround I developed.

Please have a look at my post below.

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 weekend!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Max Corbin

Mike - has this formula seen the light of day yet? Thanks!

Mike Wilday

Yes!!! Its an automation!

https://www.smartsheet.com/content-center/product-news/release-notes/new-automated-action-record-date

You might need to set up several conditions if you're trying to record each stage change, but this automation will store a date in a column of your choosing based on a certain cell changing!!!