IF(FIND()) Formula for multi-select field

Topic Labels: Formulas
826 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi! I've searched and can't seem to find a simple solution to this problem.

I have a multi-select column titled "Deliverable Owner" and there can be more than one person assigned as the Deliverable Owner.

Based on these deliverable owners, I would like to create a new column that is a formula, which segments deliverables into "Team A", "Team B", "Team C" or "Multiple Teams".

The formula ideally would work like this: If Deliverable Owner contains "John" and only "John" then assign "Team A", If Deliverable Owner contains "Ashley" and only "Ashley" then assign "Team B"...etc...and then last if Deliverable Owner contains multiple names, then assign "Multiple Teams".

Is there a simple way to achieve this? Thanks in advance!

1 Reply 1
10 - Mercury
10 - Mercury

The formula is 


IF({Deliverable Owner}="John", "Team A", IF({Deliverable Owner}="Ashley", "Team B", IF(FIND(",", ARRAYJOIN({Deliverable Owner})), "Multiple Teams")))