Nested Ifs checking for different conditions

Nick Winkley

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!

Paul Newcome

Try this...

=IF([Issue Status]@row = "Completed", "Green", IF(OR([Awaiting Status]@row<> "", TODAY() - [Issue Created Date]@row = 2), "Yellow", IF(TODAY() - [Issue Created Date]@row >= 3, "Red")))

Paul Newcome

Try this...

=IF([Issue Status]@row = "Completed", "Green", IF(OR([Awaiting Status]@row<> "", TODAY() - [Issue Created Date]@row = 2), "Yellow", IF(TODAY() - [Issue Created Date]@row >= 3, "Red")))

Nick Winkley

Still getting #UNPARSABLE error.

EDIT: Never mind! Had to change a column name and it worked. Thanks so much!

Paul Newcome

Excellent! Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.