Help

IF AND For Email Reminder

Topic Labels: Formulas
Solved
Jump to Solution
1152 2
cancel
Showing results for 
Search instead for 
Did you mean: 
KRose
4 - Data Explorer
4 - Data Explorer

I am trying to add an AND statement to this formula:

IF(
     {Date Received} = "",
     "Unsure of due date",
     IF(
        DATETIME_FORMAT({Date Received}, 'MM/DD') = DATETIME_FORMAT(DATEADD(NOW(), -14, 'day'), 'MM/DD'),
        "TRUE",
        "No match"
   )
)

The AND statement I want to be if a cell does not equal a certain value from a dropdown. So I think on its own, the and statement should be something like:

{Status} != "MoveOn"

I just can't figure out where to put each piece and how to close the parentheses. The screenshot is my table without the AND part of the formula.

Any help would be greatly appreciated!

1 Solution

Accepted Solutions
patrick-F
6 - Interface Innovator
6 - Interface Innovator

Hi @KRose ,

you should be adding the AND () function around the conditional statements in the IF() function. Below you can find an example with your formula (I was unsure whether it was meant to be in the first or in the second IF() statement, intuitively it made more sense in the second one).

Please let me know if it works! 

Best,

Patrick @MoninoSolutions


IF(
     {Date Received} = "",
     "Unsure of due date",
     IF(
        AND(
        DATETIME_FORMAT({Date Received}, 'MM/DD') = DATETIME_FORMAT(DATEADD(NOW(), -14, 'day'), 'MM/DD'), Status != "MoveOn"),
        "TRUE",
        "No match"
   )
)

patrickF_0-1720797364011.png

 

See Solution in Thread

2 Replies 2
patrick-F
6 - Interface Innovator
6 - Interface Innovator

Hi @KRose ,

you should be adding the AND () function around the conditional statements in the IF() function. Below you can find an example with your formula (I was unsure whether it was meant to be in the first or in the second IF() statement, intuitively it made more sense in the second one).

Please let me know if it works! 

Best,

Patrick @MoninoSolutions


IF(
     {Date Received} = "",
     "Unsure of due date",
     IF(
        AND(
        DATETIME_FORMAT({Date Received}, 'MM/DD') = DATETIME_FORMAT(DATEADD(NOW(), -14, 'day'), 'MM/DD'), Status != "MoveOn"),
        "TRUE",
        "No match"
   )
)

patrickF_0-1720797364011.png

 

Thank you so much, this worked!