IF Formula % Complete to Status

Options

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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!