Problems using IF formula to calculate status

Options
Miki Jeffers
Miki Jeffers ✭✭
edited 12/09/19 in Formulas and Functions

Hello,

First post for a new Smartsheet user.  I'm trying to do an status formula.  If my % Complete column is 0% then the status should read "Not Started", If the % Complete column is 100% then the status should read "Complete", any percentage in the % Complete column that is not 0% or 100% should read "In Progress".  I'm using the formula below, I'm getting a value but it's not the correct value.  Any time I change the % Complete, it doesn't update.  Any suggestions would be appreciated.

 

Formula: =IF([% Complete]47 = "0%", "Not Started", IF([% Complete]47 = "100%", "Completed", "In Progress"))

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!