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?

Find more posts tagged with

Sheets

Formulas

Groups and Group Management

Comments

Andrée Starå

Hi Gregory,

I'm not sure what you mean. Do you mean Groups that are in Smartsheet (Contacts) or your own in the sheet?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Gregory M

Sure, I'd love to clarify for you.

By Groups I mean as they are defined in "Group Management" under "Account Administration." For example, in the screenshot attached, there is a group that is defined as "Production Floor." The group allows some advanced features such as emailing all group members using only the group name, or sending notifications to the group.

My question is: can I access the group members through a formula in a sheet?

An example of this would be a formula in a cell such as:

=ISGROUPMEMBER("Production Floor",[Assigned To]1)

where the first argument would be the group name and the second argument would be the value I have in a column named "Assigned To" which is either a name or an email of the person assigned to some task I'm tracking in the sheet.

Andrée Starå

Thanks!

That's what I thought! Unfortunately, it's not possible to access contacts or groups in that way.

Great idea! Please submit an Enhancement Request when you have a moment.

It could maybe work if the contacts were somewhere in the sheet or another sheet for reference and then have a formula to check that "list".

Would that work?

Best,

Andrée

Gregory M

Thanks, Andrée.

In my case, it wouldn't work at the sheet level; there are many sheets in use and the group members do change somewhat regularly.

Doing a reference sheet might be the solution here. I was just hoping to limit the number of steps (things to update) when the members in the group change.

I'll submit an enhancement request as you suggested.

Gregory

Andrée Starå

Happy to help!

That's probably the best way at the moment.

Have a fantastic weekend!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

How to use previous cell value (from cell history) in a formula?
I have seen this question asked multiple times in the forum, but I couldn't find any clear answer provided in the answers. Please excuse me if a solution already exists, but if not, will someone please let me know if it is possible to use a previous cell value (from cell history) in a formula? I am specifically trying to…
Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
Formula for populating date
I am needing a formula that calculates Termination Date (date property). The formula needs to look at Initiation Date (date property) and Term (text/num) which is based on # months, to calculate Termination Date. In this example, the termination date should return a value of 1/01/26. Thank you!