I'm looking for a formula that would let me update the status column when the %Complete has a value entered.  It should read if 0% is entered Status would be not started; if a value of 1-99% is entered then it is in "Progress" in the status column.  If the % Complete value is 100% then the status column would show "Complete" in the status column.



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

You're welcome. Great Job.