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
iConnect (Landing Page)
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.
“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.