Formula

Frank@BSF

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.

Mike Wilday

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

Mike Wilday

Try that formula in the Status column.

Frank@BSF

That worked.. Thanks!

Mike Wilday

You're welcome. Great Job.