IF Formula Help

=IF([% Complete]@row < 0.1, "Not Started", IF([% Complete]@row > 0.1, AND ([% Complete]@row < 0.99, "In Progress", IF([% Complete]@row = 1, "Complete"))))

I need help with this formula. I need the row to say Not Started if % Complete is 0%, Complete if 100%, and In Progress otherwise. Help Please!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!