Status updating based on Schedule Health

Krusem

Hi All,

I'd like the status of a task to update based on the color of the task health.

Blue Health = Complete

Green Health = On Track

Yellow Health = At Risk

Red Health = Late

I am not sure the formula I should be using.

Thanks!

Paul Newcome

You would use a nested IF statement.

There are some examples of a nested IF in this article.

https://help.smartsheet.com/function/if