Nested Ifs checking for different conditions

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!