Dynamic View and Groups

rachmavis

I have a Sheet with sentitive data. I need to share certain rows to Groups of people. Row A, Group Admin SHS can view. Row B, Group Admin BSH can view. Group. Admin BSH should not see Row A.

Groups have been created.

When I go to the sheet, I can't see the groups to add to a row I assume in Dynmaic view, when these Groups log in to see only their data, they need to be assigned to rows in a column…

Brian_Richardson

You cannot filter data by groups, only by individual contacts. Smartsheet Groups are only for sharing and don't work in contact columns.

As a workaround, in your sheet you can identify the group in a column, then have an INDEX/MATCH that looks up that group on a reference sheet and picks up the list of contacts. In your reference sheet you'll need to have two columns…one with the group name to match to, and one contact column with the list of people in the groups.