Update Status formula - late versus complete

Options
BJIloveSmartSheet
edited 04/18/23 in Smartsheet Basics

Howdy,

Question. I am using a status formula:

=IF(Finish@row < TODAY(), "Late", IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", "In Progress")))

This formula populates the status based on the % complete and due date. It works well, with one exception. If the % complete is marked 100% after the due date, the status remains "Late", when it's actually 100% complete. The 100% complete needs to override the "Late" status.

Any ideas on how to modify this formula? Attached is a screenshot displaying the issue.

Thanks!


Tags:

Best Answer

Answers