IF AND BLANK formula not working for attachment field

[hauwi]

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)! 🙂

[TheTimeSavingCo]

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

 

[hauwi]

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?

[hauwi · Accepted solution]

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(),

[dilipborad]

Hello @hauwi 

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

Please give 👍 and mark this as solved.