nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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

Find more posts tagged with

Formulas

Project Management

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

SUMIFS formula bringing back total of all items, not items in specified date range.
Hello, I'm using a SUMIFS formula to try and get the sum of materials, done during a specific process, during the specified date range of May 04 2026 - May 08 2026. But it continues to total all entries in that column, instead of giving the total based on the provided data. I've also tried using both OR and AND functions…
Using a checkbox in formula
Hello All, My existing formula (working correctly) inserts text of REORDER NEEDED or OK option , formula below: =IF([Stock Quantity]32 < [Reorder Level]32, "REORDER NEEDED", "OK") I would like to add a third text insert of "ORDERED" when criteria of a checkbox has been checked in the ON ORDER column -or a date ordered…
Abnormal Display of Hyperlink Content in Notification Emails
Hello, Team Our team has encountered an issue while using Smartsheet. We have applied the Hyperlink function in a data management sheet to link the Quote ID to the corresponding sheet. This hyperlink is integrated into the automation workflow of Approval Requests. When a requester initiates the approval flow, the hyperlink…