Sheet formula to access members in a group

Gregory M
Gregory M
edited 12/09/19 in Formulas and Functions

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?

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!