Status corresponding to % Complete

Brett Macias

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.

Paul Newcome

Try something like this...

=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", "In Progress"))