One DView that shows rows based on a team
I am looking for a way to reduce the number of views to build for a sheet that filters by team:
Currently I have Team A, Team B, Team C etc.
I build a view for each of the teams and set the "Restrict view by sheet filter" to the respective team filter
We have a lot of teams and therefore a lot of DV's to build and maintain.
I was hoping someone knew of a better way to set it up, similar to setting the DV up to "restrict view by current user" but instead of a single user it would allow the members of the team to see that view.
Has anyone worked on a similar use case and come up with an idea?
Someone told me to set the Team Column up as a contact column, but I don't know how smartsheet or DV would know which users belongs to which team.
thanks for any ideas or help you may have.