Please help... calculated column based on column multiple choice selections (from the same table)


#1

I am hoping someone can offer a suggestion on the formula needed to create a calculated column based the following:

I have a column named: Project Tasks include

The following options are multiple choice selections for the above mentioned column
SFDC Campaign
Eloqua Campaign
Hero
Landing Page
iConnect (Landing Page)
e-communication
Educational Webinar
AFSC Presentation

Based on the selection of the choices selected above, in the same table, I’d like to create an “Assigned To” calculated column, so as soon as any of these items above are selected, the “assigned to” column will automatically populate with a specific name (or specific names) of whom is responsible for the selected task or tasks.

Can anyone offer guidance?
Thanks,
Suz


#2

To can use a SWITCH() statement, like so:

SWITCH(
   {Project Tasks},
   “SFDC Campaign”, “So-and-so”,
   “Hero, e-communication”, “Such-and-such”,
   ... and so on

For each combination of options, you’d need to make sure that if it’s multiple tasks being chosen, they are chosen in the same order each time (ie, “Hero”, THEN “e-commerce”), or else define both combinations in the SWITCH statement and assign each combination to the same person.


#3

Excellent… thank you! I will use this switch statement today! Thanks again :slight_smile: