Using a formula to assign multiple contacts
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.
Cell1 - [email protected]
Cell2 - [email protected]
Formula: Cell1 + Cell2
This then just creates a new contact that's called [email protected]@test.com
Is it possible to use a formula to assign multiple people in the same cell?