Help

How do I write an IF function that looks for an element in a multi-select column as it's condition

Topic Labels: Formulas
Solved
Jump to Solution
548 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Solomon12345
4 - Data Explorer
4 - Data Explorer

I am trying to write an IF function such that the condition in the statement is to look for the presence of a particular word in a multi-select column. If the word is present in the multi-select, the value-if-true should be displayed. 

In a multi-select column, there is a list of amenities: Airconditioning, Lounge, Studio, etc. I want to create a new formula column that looks for "Studio" in the multi-select column. If it is present then show Yes, if it's not show "No". Something like this: IF(Amenities="Studio", "Yes", "No"). This gives me the correct output if the only value selected is Studio. In the case where the column has "Lounge" and "Studio", I get No as the output.

 

1 Solution

Accepted Solutions
Adrienne_Medina
5 - Automation Enthusiast
5 - Automation Enthusiast

You can use a Find function for this:

IF(FIND("Studio", {Field}), "Yes","No")

See Solution in Thread

2 Replies 2
Adrienne_Medina
5 - Automation Enthusiast
5 - Automation Enthusiast

You can use a Find function for this:

IF(FIND("Studio", {Field}), "Yes","No")

Solomon12345
4 - Data Explorer
4 - Data Explorer

Thank you. It works!