Auto Status Change/Update

rochen

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

Give this a try...

 

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

rochen

hi,

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

Paul Newcome

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

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

Paul Newcome

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

These are my columns:

Task name

Duration

Start (dates)

finish (dates)

Predecessors

Status (red,green,yellow symbols

completed (checkbox) 

Paul Newcome

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

 

=IF(AND(completed@row = 0, TODAY() - (Start@row + Duration@row) > 0), "Delayed")