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.