"=IF" statement not generating correct response all of the time


Hi Everyone!

I am trying to get my status column to change based upon what the number is the [% Complete) column is. Here is what I would like the desired results to be:

0= "Not Started"; 100="Complete"; and anything else from 1-99 would be "In Progress"

Here is the formula that I have tried, but it's not catching that 100% should be "Complete".  

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

Here is screenshot of the error.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!