Is there a way to use an export of User List from the User Management list in Smartsheet Admin Center to create a master list that can be used to automatically update Contact List columns with a common column name and function across many sheets? Right now, I am manually keeping individual sheet contact lists updated as people come and go from our organization.
Example: A contact list in a column named Project Assigned To is common to several dozen sheets. Employee A just joined the company and has been added to Smartsheet in User Management. I then add Employee A to a sheet where I keep a master list of all employees+emails. That same sheet includes additional contact list columns that include groups, which mirror how my groups are organized in SS Admin Center Group Management. I want to somehow add Employee A to the Project Assigned To contact list on several dozen sheets, without having to open each sheet and manually add Employee A to the Project Assigned To contact list.
I tried a Pro Desk session and didn't get very far, the reason being that the function needs to be done at the Column Type level and not at the row level.
Can anyone out there help? I can't imagine that this isn't a common problem for many.
TIA
