IF Formula % Complete to Status


Hello - I need some help. I think I am close but my formula isn't working. This is what I'm trying to accomplish:


% Complete => Project Status

Blank = Not started

less than 100% = In progress

100% = Complete


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

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!