Using a formula to assign multiple contacts

Good morning!

I am having a difficult time using a formula to assign multiple contacts. I have the checkbox selected to allow multiple contacts, but it seems as though when it comes to a formula, the cell is only seeing it as text.

Example:

Cell1 - megan@test.com

Cell2 - jones@test.com

Formula: Cell1 + Cell2

This then just creates a new contact that's called megan@test.comjones@test.com

Is it possible to use a formula to assign multiple people in the same cell?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!