Hello,
I am trying to add an additional argument to a formula to check if a cell called "Awaiting Response" is not blank, and if so, change a RYG cell to yellow instead of red, but I am getting either #UNPARSABLE or #INCORRECT ARGUMENT SET. The conditions are all based on when the last response was to a ticket, with more than 3 days being red and 2 days being yellow.
=IF(
AND(
[Issue Status]@row <> "Completed", TODAY() > ([Issue Created Date]@row + 3)
), "Red",
IF(
OR(
AND(
[Issue Status]@row <> "Completed", TODAY() > ([Issue Created Date]@row + 2)
),
NOT(
ISBLANK(
[Awaiting Status]@row
)
)
)
), "Yellow", "Green"
)
Any help would be appreciated. Thanks!
