Auto Status Change/Update

rochen · 08/23/18

Hi,

I am trying to create a tracked schedule and was wondering if smartsheet had an option or setting that auto updated status based on the date entered and real time date. For example if a phase is due at 08/24/2018 and it is 08/25/2018 and the status box of completion is not checked yet, is there a way to create something that will automatically say delayed or something of that sort until the box is checked?

Paul Newcome · 08/23/18

Give this a try...

=IF(TODAY() - [Due Date Column Name]@row > 0, "Delayed")

rochen · 08/23/18

hi,

It did not seem to work on my end! but thank you!!

Paul Newcome · 08/23/18

I missed the Complete portion in the first formula.

=IF(AND([Complete Column Name]@row = 0, TODAY() - [Due Date Column Name]@row > 0), "Delayed")

What didn't work for you? Did you get an error message, or was it that I had forgotten to include the AND part?

rochen · 08/23/18

It gives me the error message of invalid operation or unparseable.

Paul Newcome · 08/23/18

How are your columns formatted, and what are the names of them? I may be able to give you something more specific to your need as opposed to a semi-generic formula as above.

rochen · 08/23/18

These are my columns:

Task name

Duration

Start (dates)

finish (dates)

Predecessors

Status (red,green,yellow symbols

completed (checkbox)

Paul Newcome · 08/27/18

I don't see a "Due Date" column. Without that you would need something along the lines of

=IF(AND([email protected] = 0, TODAY() - ([email protected] + [email protected]) > 0), "Delayed")

Auto Status Change/Update

Comments

Help Article Resources

Categories