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; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

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

Recent Discussions
Customer Resources
Badge Dashboard
Groups
Unanswered Questions
Community Guidelines

Trending discussions

Using HAS function with SUMIF - multiple references
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
Automated Messages Being Truncated- Does anyone have a workaround?
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
How to enlarge cell formula reference limit
I have a sheet with 5000 rows and 30 columns. with 4 columns of them are formular columns. How can i reach this limit for 25000000 formular cells reference? How can i enlarge this limit? I need those formular to link some data from another sheet as there is also Max cells limit for one sheet. How can I join those data…