Formula to determine the date that another cell was updated

Andrea Mayer

Hello,

Looking for some formula help. I am using the formula below and need to figure out how to display the date the Status cell was changed instead of updating to today's date.

=IF([Status]1 = "Completed", TODAY())

Thanks for your help!

Andrea

Andrée Starå

Hi Andrea,

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

You could use the cell history or the Activity log, but it won't work in a formula.

Another option would be to use a third-party solution like Zapier or similar.

Would any of those options work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrea Mayer

Hi Andree,

Thank you for your fast reply!

I have submitted an Enhancement Request via the link provide above. We will look into these other options for solving our issue with this formula.

Have a great weekend!

Andrea

Andrée Starå

Happy to help!

Best,

Andrée