# Formula with multiple values

Topic Labels: Formulas
Solved
676 3
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hi there, I’m looking to create a formula column based off a column which has multiple fields.

The Column has one or multiple of SD/HD, UHD, HDR or SDR.

I want to create a new column called “Available in UHD?” where if one of UHD, HDR or SDR is there then show Yes. If it has only SD/HD then show no.

Any help would be appreciated.

1 Solution

Accepted Solutions
7 - App Architect

Hi Jason,

Welcome to the Airtable community!

The formula that you are looking for would look something like this:

``IF(OR(FIND("UHD", {Multiple Select}), FIND("HDR", {Multiple Select}), FIND("SDR", {Multiple Select})), "yes", "no")``

To add some context to the formula, I used the FIND( ) function to search the multiple select field for the specific string I'm interested in, as long as it appears within the multiple select it will come back with a positive result that I can leverage in my IF statement. To check the condition of any of UHD, HDR, or SDR I use the OR( ) function with three FIND( ) functions nested as my three logicals. If any of the three are true then the IF( ) statement will return true, if it is true I ask the formula  to return "yes" and "no" if false (ie none of the three options were found).

I hope this helps! Let me know if you have any questions.

Chantal

3 Replies 3
7 - App Architect

Hi Jason,

Welcome to the Airtable community!

The formula that you are looking for would look something like this:

``IF(OR(FIND("UHD", {Multiple Select}), FIND("HDR", {Multiple Select}), FIND("SDR", {Multiple Select})), "yes", "no")``

To add some context to the formula, I used the FIND( ) function to search the multiple select field for the specific string I'm interested in, as long as it appears within the multiple select it will come back with a positive result that I can leverage in my IF statement. To check the condition of any of UHD, HDR, or SDR I use the OR( ) function with three FIND( ) functions nested as my three logicals. If any of the three are true then the IF( ) statement will return true, if it is true I ask the formula  to return "yes" and "no" if false (ie none of the three options were found).

I hope this helps! Let me know if you have any questions.

Chantal

4 - Data Explorer

Success! Thanks so much Chantal!

4 - Data Explorer

If you are looking for a string in a multi select field,  and you want to find it case sensitive.   You can use this simple formula:

IF(REGEX_EXTRACT(LOWER(Labels),"incomplete")= "incomplete", "Incomplete","")

where Labels is a multi-select column.   Here we are looking for the string "incomplete" regardless of case.  If found, add the value of "Incomplete" to the new field else add the empty string.