Need help combining IF statements (SOLVED)


#1

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!


#2

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:”)

#3

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.