Formula

Frank@BSF
Frank@BSF
edited 12/09/19 in Formulas and Functions

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.

Formula.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!