Jul 03, 2023 08:03 AM
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!
Jul 03, 2023 12:50 PM - edited Jul 03, 2023 02:56 PM
The formula is
IF({Deliverable Owner}="John", "Team A", IF({Deliverable Owner}="Ashley", "Team B", IF(FIND(",", ARRAYJOIN({Deliverable Owner})), "Multiple Teams")))
Sep 17, 2024 04:09 PM
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.