Formula with multiple values

[Jason22]

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.

[AirOps · Accepted solution]

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

[Jason22]

Success! Thanks so much Chantal!

[geneF]

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.