Skip to main content

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

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.


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.



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


Reply