I am looking for a formula that will auto populate the symbols in my "Flag" column.
If "Status" is equal to "Complete" - Gray
If "Requested Due Date" is prior to "Requested Due Date" AND "Status" is not equal to "Complete" - Green
If "Requested Due Date" is equal to "Requested Due Date" AND "Status" is not equal to "Complete" - Yellow
If "Requested Due Date" is after to "Requested Due Date" AND "Status" is not equal to "Complete" - Red
I tried the bellow but it didn't work.
=IF([Status]@row="Complete", "Gray",
IF([Requested Due Date]@row>TODAY(), [Status]@row<>"Complete"), "Green",
IF([Requested Due Date]@row=TODAY(), [Status]@row<>"Complete"), "Yellow",
IF([Requested Due Date]@row<TODAY(), [Status]@row<>"Complete"), "Red",))))
Any help, would be greatly appreciated.
Thank you,
Daniel
