IF AND For Email Reminder

Question

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!

patrick-F · Accepted Answer

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 @MoninoSolutionsIF(     {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"   ))

KRose · Answer

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 @MoninoSolutionsIF(     {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"   )) Thank you so much, this worked!

IF AND For Email Reminder

1 Attachments

2 replies

1 Attachments

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded