Skip to main content

Need help combining IF statements (SOLVED)

  • January 8, 2019
  • 2 replies
  • 29 views
E
Forum|alt.badge.img+4

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

      B
      Forum|alt.badge.img+3
      • bdelanghe
      • Known Participant
      • January 8, 2019

      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:”)
        E
        Forum|alt.badge.img+4
        • Erin_Thiele
        • Author
        • Participating Frequently
        • January 9, 2019

        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.

          Terms & ConditionsAccessibility statement