Nested IF Statement

[Erin_Thiele]

I have two IF statements that work independently. I cannot figure out what I’m doing wrong to combine them to be an AND.

First: IF(DATETIME_DIFF(TODAY(),{Date Quote Submitted},‘days’)>30,“ :rotating_light: URGENT​:rotating_light:”)

Second: IF(STATUS = “QIP - Submitted”," :rotating_light: URGENT​:rotating_light:”)

I want to combine them so any line that has “QIP - Submitted” status and is 30 days or more prior to today is marked as :rotating_light: URGENT​:rotating_light:

Thank you friends!

[bdelanghe]

Easiest way in this case is adding an AND function:

 IF(AND(DATETIME_DIFF(TODAY(),{Date Quote Submitted},‘days’)>30,STATUS = “QIP - Submitted”),“:rotating_light:URGENT​:rotating_light:”)

[Erin_Thiele]

Thanks! I figured out it was the curved quotations that is messing it up when I copy and paste. I appreciated the confirmation of my formula.