Send Automated Alert to Group
Is it possible to send an automated alert to a group? It looks like the only options are to specific people, contacts in a cell, and everybody shared to the sheet. I have two groups shared to the sheet, one has Editor capabilities while the other is just a Viewer. Is it possible to send to just one of these two groups?
If that is not an option, is there a way of getting all of the contacts in a column into a single cell? Each row in the sheet has the contact of one person in the first group. Is there a way to "collect" all of the people in a column and bring them into a single cell. I could then replicate this onto every row, so anytime there is a new form entry, the entire list is there, and the entire group would be notified.
Thanks for the help.