Greater Than - Less Than Formula

Smartsheet Community:

Im trying to get a result of In Progress when % Complete is greater than 0 but less than 100.

Current Formula:

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

I am not sure where my error is. All Help Appreciated.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!