Skip to main content
Solved

Nested IF Statements with Two Columns/Conditions

E

Hello all,

This is my first post to the community. I’ve seen other posts similar to this topic, but they don’t quite address what I’m trying to achieve.

I’m having an issue with a nested IF statement and not sure whether a combination SWITCH/IF would be best for this formula.

I have two columns - column 1 (Date) and column 2 (Location) that is single select. I want a third column (Status) that returns a value based on what is populated in the first two.

Logical Argument 1: If column 1 (Date) is not blank OR column 2 (Location) is ‘Outside Area’, the Status column should return “Yes”.

Logical Argument 2: If column 1 (Date) is blank the Status column should return “No”.

Any help would be greatly appreciated.

@Jeremy_Oglesby

Best answer by ScottWorld

Welcome to the community, @Embrace_Your_Hustle!

You technically don’t need a nested IF statement, because logical argument #2 will ALWAYS be true if logical argument #1 fails.

So your formula would be pretty simple… it would look like this:

IF(
OR({Date},{Location}="Outside Area"), "Yes", "No"
)

View original
Did this topic help you find an answer to your question?

6 replies

ScottWorld
Forum|alt.badge.img+33
  • ScottWorld
  • Brainy
  • 8761 replies
  • Answer
  • May 20, 2020

Welcome to the community, @Embrace_Your_Hustle!

You technically don’t need a nested IF statement, because logical argument #2 will ALWAYS be true if logical argument #1 fails.

So your formula would be pretty simple… it would look like this:

IF(
OR({Date},{Location}="Outside Area"), "Yes", "No"
)

E
1 person likes this
  • E
    Embrace_Your_Hu
E

Thank you so much @ScottWorld! :clap: :clap: I was completely over complicating it. :grinning_face_with_sweat:

ScottWorld
1 person likes this
  • ScottWorld
    ScottWorld
ScottWorld
Forum|alt.badge.img+33
  • ScottWorld
  • Brainy
  • 8761 replies
  • May 20, 2020
Embrace_Your_Hu wrote:

Thank you so much @ScottWorld! :clap: :clap: I was completely over complicating it. :grinning_face_with_sweat:


Haha, you’re welcome! :stuck_out_tongue_closed_eyes:

E

Hi @ScottWorld, I got the formula to work in my test table, but had trouble making it work in my production environment. The concept is the same, but the column names are different, which I wouldn’t think would make a difference as long as they are updated. I figured it out though, someone had entered a space after the text in the single select text option. Is there a way to add a wildcard/like operator to the = text area?

IF(
OR({Date},{Location}=“Outside Area”), “Yes”, “No”`
)

Also, is the first part of the logic checking for to confirm whether the Date field is blank?

Thanks again!

ScottWorld
Forum|alt.badge.img+33
  • ScottWorld
  • Brainy
  • 8761 replies
  • May 20, 2020
Embrace_Your_Hu wrote:

Hi @ScottWorld, I got the formula to work in my test table, but had trouble making it work in my production environment. The concept is the same, but the column names are different, which I wouldn’t think would make a difference as long as they are updated. I figured it out though, someone had entered a space after the text in the single select text option. Is there a way to add a wildcard/like operator to the = text area?

IF(
OR({Date},{Location}=“Outside Area”), “Yes”, “No”`
)

Also, is the first part of the logic checking for to confirm whether the Date field is blank?

Thanks again!


Yes, that’s what {Date} on its own is checking for. The existence of data there.

E
1 person likes this
  • E
    Embrace_Your_Hu
Justin_Barrett
Forum|alt.badge.img+20
Embrace_Your_Hu wrote:

Hi @ScottWorld, I got the formula to work in my test table, but had trouble making it work in my production environment. The concept is the same, but the column names are different, which I wouldn’t think would make a difference as long as they are updated. I figured it out though, someone had entered a space after the text in the single select text option. Is there a way to add a wildcard/like operator to the = text area?

IF(
OR({Date},{Location}=“Outside Area”), “Yes”, “No”`
)

Also, is the first part of the logic checking for to confirm whether the Date field is blank?

Thanks again!


I noticed that this part of your follow-up wasn’t answered. Airtable doesn’t currently support wildcards or other means of pattern matching (i.e. regular expressions). The closest it has are the FIND() and SEARCH() functions, either of which would work in your situation. Here’s the updated formula using FIND():

IF(OR(Date, FIND("Outside Area", Location)), "Yes", "No")

This also adds the ever-so-slight optimization of removing unnecessary curly braces from around the field names. Curly braces are not required for single-word field names, as long as they don’t contain special characters. A field name that’s only numbers, or one that contains spaces or special characters, will require braces around it in your formulas.

E
1 person likes this
  • E
    Embrace_Your_Hu

Reply


Most helpful members this week

Terms & Conditions