Activity Health

edited 03/25/24 in Formulas and Functions

I am trying to recreate a previous formula I used and am not sure where I messed up for task health. Can someone help me find what is causing my IRERROR function to be true for rows 1 & 2?

Formula Used:

=IFERROR(IF(ISBLANK([% Complete]@row), "", IF(Status@row = "Complete", "Gray", IF(AND([Start Date]@row < TODAY(), Status@row = "Not Started"), "Red", IF(AND([End Date]@row < TODAY(), Status@row <> "Complete"), "Red", IF(NETWORKDAYS([Start Date]@row, TODAY()) / NETWORKDAYS([Start Date]@row, [End Date]@row < [% Complete]@row), "Green", "Yellow"))))), "ERROR")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!