Status corresponding to % Complete


I would like to figure a way for the Status Column to auto fill depending on what the % Complete says.

For instance:

0% = Not Started

1-99% In Progress

100% - Complete

Conditional Formatting is not the way to go and I can't figure out the right If/Then statement to use.

New to this world so don't think down on me too much.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!