Skip to main content

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!

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"
)
)

 

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"
)
)

 


Thank you so much, this worked!

Reply


Terms & Conditions