Skip to main content

Hi. I'm struggling with a formula to include a blank attachment field as part of 3 AND conditions. I'm testing this in my base before I put the AND part into a make.com airtable trigger module.

At the moment, I have this:

 

 

IF(
AND(
{Ind Doc}!=BLANK(),
DATETIME_DIFF(
NOW(),{Record Created}, "days"
)
>13,
DATETIME_DIFF(
NOW(),{Record Created}, "days"
)
<30),
"YES",
"NO"
)

 

This works, but ignores the first parameter and returns "YES" even for records that have an attachment in {Ind Doc}

(Sorry if syntax for the multi-line formula is incorrect, I'm only just starting to learn to write formulas like this)! 🙂

 

Try just doing "{Ind Doc}" instead?  So you'd end up with:

 

IF(
AND(
{Ind Doc},
DATETIME_DIFF(
NOW(),{Record Created}, "days"
)
>13,
DATETIME_DIFF(
NOW(),{Record Created}, "days"
)
<30),
"YES",
"NO"
)

 

Here's an example where I just did:

 

IF(
Attachments,
"True",
"False"
)

 

 

Try just doing "{Ind Doc}" instead?  So you'd end up with:

 

IF(
AND(
{Ind Doc},
DATETIME_DIFF(
NOW(),{Record Created}, "days"
)
>13,
DATETIME_DIFF(
NOW(),{Record Created}, "days"
)
<30),
"YES",
"NO"
)

 

Here's an example where I just did:

 

IF(
Attachments,
"True",
"False"
)

 

 


Hi Adam. Thank you, I did try this and it makes no difference. Do you think it might be something to do with me having 3 parameters in the AND formula? - Or maybe because two of those parameters reference the same field?

Solved it! Removing the exclamation mark did the trick. (No Idea why, so an explanation would be gratefully received). 😊

I am still a bit new to all this.

 

{Ind Doc}!=BLANK(),

 

 ... to make ...

 

{Ind Doc}=BLANK(),

 

 

Hello @hauwi 

It's you get a solution based on @TheTimeSavingCo answer.

Please give 👍 and mark this as solved.

Reply


Terms & Conditions