Formula that Automatically changes Date when cell changes

Is there a formula that would automatically change its date to reflect the date a cell or column changes?

For example, I am creating a sheet where I want a formula that changes its date to reflect anytime someone changes the task, so the person changing the task's status doesn't have to change the date they updated the task either. Instead it automates for them.

Thanks in advance!

Find more posts tagged with

Construction

Formulas

Project Management

Comments

Andrée Starå

Hi Julie,

You could maybe use the Modified column to get the date of the latest change on the row/task, but it would only work if that is the only change.

Another option would be the third-party service/integration Zapier, which is an excellent option for this scenario. Is that an option for you?

Would any of those methods work?

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])