Row Status Indicator in Schedule

delaurellc

Wrote a formula to check two items and change and indicator light. Here is the code but it is saying incorrect argument set?

=IF(Status@row <> "Complete", [Due Date]@row < TODAY(), "Red", IF(Status@row <> "Complete", [Due Date]@row >= TODAY(2), "Yellow", "Green"))

I have reviewed everything multiple times and cannot figure out what I am missing, I even verified with formula template. What am I doing wrong here?

I am writing in notepad and transferring over to the formula builder

Caroline

delaurellc

I figured out the code and here it is in case anyone is trying to do the same thing

=IF(AND([Due Date]@row < TODAY(), Status@row <> "Complete"), "Red", IF(AND([Due Date]@row = TODAY(2), Status@row <> "Complete"), "Yellow", "Green"))

Caroline

delaurellc

I figured out the code and here it is in case anyone is trying to do the same thing

=IF(AND([Due Date]@row < TODAY(), Status@row <> "Complete"), "Red", IF(AND([Due Date]@row = TODAY(2), Status@row <> "Complete"), "Yellow", "Green"))

Caroline

Genevieve P.

Awesome! Thanks for sharing your solution