Sheet formula to access members in a group
I've created a Group and can track assigned tasks in a Resource View with the group dynamically. Is there a way to access the group list in a formula on a sheet?
In my sheet, there is an "Assigned To" column which is a Contact List type column. The cell can be assigned to group members and non-group members. The next column, "Group Member," is a Checkbox type column. Is there a formula I can use to automatically check the box in the "Group Member" column if the name/email in the "Assigned To" column is included in the group?
Help Article Resources
Check out the Formula Handbook template!