Help

IF AND BLANK formula not working for attachment field

Topic Labels: Formulas
Solved
Jump to Solution
343 4
cancel
Showing results for 
Search instead for 
Did you mean: 
hauwi
6 - Interface Innovator
6 - Interface Innovator

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

 

1 Solution

Accepted Solutions
hauwi
6 - Interface Innovator
6 - Interface Innovator

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

 

 

See Solution in Thread

4 Replies 4

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

Screenshot 2024-03-02 at 8.01.11 PM.png

 

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
6 - Interface Innovator
6 - Interface Innovator

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
8 - Airtable Astronomer
8 - Airtable Astronomer

Hello @hauwi 

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

Please give 👍 and mark this as solved.