Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

# IF AND For Email Reminder

Topic Labels: Formulas
Solved
792 2
cancel
Showing results for
Did you mean:
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
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"
)
)``````

2 Replies 2
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"
)
)``````

4 - Data Explorer

Thank you so much, this worked!