IF Formula with Multiple Choice

Clayton DSouza

Hello!

I want to build an IF formula into columns when the multiple boxes has selected the right department.

IF the Authorizer is marketing and finance, the emails would automatically populate in marketing and finance column. Not sure if this can be done.

Would appreciate your help greatly!! Thank you very much.

Clayton DSouza

@Andrée Starå

it worked!! Thank you so much for your help.

=IF(HAS(Authorizer@row, "Catering"), "Steve@abc.com")

=IF(HAS(Authorizer@row, "Marketing"), "dave@abc.com")

=IF(HAS(Authorizer@row, "Finance"), "mark@abc.com")

Andrée Starå

Hi @Clayton DSouza

I hope you're well and safe!

Are the email addresses always the same?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Clayton DSouza

@Andrée Starå

Yes, the email for each division is the same.

Thank you!

Andrée Starå

@Clayton DSouza

Happy to help!

You could add a Workflow combined with the Assign People Action to add the contact when the correct options are selected.

Would that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Clayton DSouza

@Andrée Starå

I have used workflows and there are close to 10 divisions and that would be 10 different workflows.

I was exploring if there is a formula that could be used to merge them.

Andrée Starå

@Clayton DSouza

Aha! That's why I asked if they always were the same.

You would either need to add a multiple IF formula that checks one by one or add a directory in the same or another sheet to collect the correct contact.

Make sense?

Would any of those options work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Clayton DSouza

@Andrée Starå

I am sorry, i dont understand.

so currently I have the following formula in each column.

=IF(Authorizer@row = "Marketing", "Dave@ABC.com")

=IF(Authorizer@row = "Finance", "Mark@abc.com")

=IF(Authorizer@row = "Catering", "Steve@abc.com")

But in my authorizer column, if I select more than one division, the formula doesn't work.

Andrée Starå

@Clayton DSouza

Ok, I see. You need to replace it with the HAS function instead.

HAS Function | Smartsheet Learning Center

https://help.smartsheet.com/function/has

Searches for an exact match of a single value, including if this value appears in a multicontact or multiselect dropdown column cells or ranges with other values. If HAS finds the exact match, it returns "True." Otherwise, it returns "False."

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Clayton DSouza

@Andrée Starå

it worked!! Thank you so much for your help.

=IF(HAS(Authorizer@row, "Catering"), "Steve@abc.com")

=IF(HAS(Authorizer@row, "Marketing"), "dave@abc.com")

=IF(HAS(Authorizer@row, "Finance"), "mark@abc.com")

Andrée Starå

@Clayton DSouza

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!