Comments
-
This fixed it, thank you! For anyone referencing this in the future, I also fixed the formula details so the output was fully correct and consistent: =IF([Percent Complete]@row = 100, "Blue", IF(AND([Percent Complete]@row < 100, (([Due Date]@row) < TODAY())), "Red", IF(AND([Percent Complete]@row < 100, (([Due Date]@row) <=…
-
Update: I think it might be something flawed in my Date conditionals because the Percent complete conditions work fine on their own.