Skip to main content

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!

The formula is 

 

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

How to handle in case where we have 1 option as a string subset of another, i.e. 1 option in multi-select is John and other option are Johnny, JohnnyR. If I use above formula and want to print something when I see only 'John', the find doesn't work. It includes Johnny and JohnnyR too.

Reply


Terms & Conditions