Status related to % Complete

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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!