Contact list of users

kpassfield

Hi, We are currently creating a sheet/form for staff to submit a trip plan. This requires noting each staff member travelling in the vehicle so a new column for each staff, which then pulls through their emergency contact information.

At the moment, for each column, I am having to add the staff names to the contact list so they are available to select from the drop down. They are users, so I have to just select each name. However this means every time we get a new staff member or someone leaves I would have to go through every column and add/remove.

Is there a way the contact list column type can automatically lookup the users in our organisation? I should be able to say 'contact list' type then opt to add all organisational users so as we have staffing changes the list is updated.

Thanks

Tim C

Yep! Data shuttle can update dropdown lists dynamically. Check out the article here https://community.smartsheet.com/discussion/98805/new-help-article-create-dynamic-dropdowns-with-data-shuttle. Pro tip for reassignment of the people no longer in thay column. Use data shuttle to update the dropdown list first, then use ctrl+F to find the contact you want to replace and just use "replace all" with the new contact (it's one way to do it quickly)