Activity Health

malmcfall

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")

Hollie Green

IF(NETWORKDAYS([Start Date]@row, TODAY()) / NETWORKDAYS([Start Date]@row, [End Date]@row < [% Complete]@row), "Green", "Yellow") this part of the formula is what is causing the error

It should be the below the ) was in the incorrect place.

=IF(NETWORKDAYS([Start Date]@row, TODAY()) / NETWORKDAYS([Start Date]@row, [End Date]@row) < [% Complete]@row, "Green", "Yellow")

malmcfall

Thank you @Hollie Green