Status related to % Complete

E Redd

I am trying to accomplish the following formula:

100% status turns green

1%-99% status turns yellow

0%= Gray

work paused = red

Is this possible with red?

Devin Lee

It would look something like this

=IF(Status@row="work paused","Red",IF(Status@row=0,"Gray",IF(Status@row=1,"Green","Yellow")))

Devin Lee

It would look something like this

=IF(Status@row="work paused","Red",IF(Status@row=0,"Gray",IF(Status@row=1,"Green","Yellow")))

E Redd

Thank you Devin!

It didn't entirely work for me. States "Circular reference", but I did modify to use.