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.
Can anyone offer guidance?