Help

Re: Formula that selects a category and/or two checkboxes

Solved
Jump to Solution
1898 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Tchong
5 - Automation Enthusiast
5 - Automation Enthusiast

I have been trying to figure out how to write this formula:

Where Category is any of “macOS”
AND checkbox Universal is checked
OR checkbox Intel is checked.

Here are two of my approaches:

IF(Category = "macOS", AND(Universal = 1), OR(Intel = 1), "true")

IF(AND(Category = "macOS", OR(Universal = 1, Intel = 1)), "true")

Can anyone tell me what I’m doing wrong?

1 Solution

Accepted Solutions

@Michael_Tchong

  1. Like @ScottWorld says, your field Category doesn’t add upp to just “macOS”, it adds upp to “Application, macOS” which is not the same and Airtable, correctly, doesn’t apply the rule.
    For this you need to use FIND(), so each time it finds that category anywhere (as first, second, :nth) it will apply the rule.

IF(AND(FIND('macOS',Category & ""), OR(Universal=1, Intel=1)), 'true')

  1. In your screenshot the checked checkbox field is not called either “Universal” or “Intel”, but I asume that is just a screenshot matter. If not, you need to make sure that the name of the field matches the name in the formula exactly.

See Solution in Thread

5 Replies 5
momentsgoneby80
7 - App Architect
7 - App Architect

Hi @Michael_Tchong!
Your formula works like you describe for me.

example_formula-test

In what way do you find that it doesn’t, so I can begin to understand what you are after?

When I use that formula, I get a blank results field, see screenshot.

Airtable screenshot

For those records that you’re showing in your screenshot, the category field is not equal to macOS.

For those records, the category field is an array of many strings, one of which is macOS.

So you can’t say:
Category = "macOS"

Instead, you will need to use the FIND function like this:
FIND("macOS",Category & "") > 0

(It might also work without the & "" part, but I’m not sure. Adding that definitely converts the array into a searchable string.)

@Michael_Tchong

  1. Like @ScottWorld says, your field Category doesn’t add upp to just “macOS”, it adds upp to “Application, macOS” which is not the same and Airtable, correctly, doesn’t apply the rule.
    For this you need to use FIND(), so each time it finds that category anywhere (as first, second, :nth) it will apply the rule.

IF(AND(FIND('macOS',Category & ""), OR(Universal=1, Intel=1)), 'true')

  1. In your screenshot the checked checkbox field is not called either “Universal” or “Intel”, but I asume that is just a screenshot matter. If not, you need to make sure that the name of the field matches the name in the formula exactly.
Michael_Tchong
5 - Automation Enthusiast
5 - Automation Enthusiast

Bingo! That worked! Thanks heaps folks, this is a great community. :clap: :slightly_smiling_face: