Help

Re: Need help combining IF statements (SOLVED)

468 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Erin_Thiele
5 - Automation Enthusiast
5 - Automation Enthusiast

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 Replies 2
bdelanghe
7 - App Architect
7 - App Architect

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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.