I have a contact sheet and a main sheet. There are instances when I have 2-3 individuals that need to be notified based on the information on the main sheet. I created this formula to pull multiple emails from the contact list:
=JOIN(COLLECT({Department Chairs}, {CourseName}, CONTAINS([APA Courses]@row , @cell )), CHAR(10))
The problem is that the Contact Cell on the main sheet is not recognizing the contacts as contacts. I think it is because they are not being delimitated???
Is there any way to get the emails to populate correctly as separate contacts?
