Contact list of users
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
Answers
-
Hi @kpassfield
I noticed that if you don't use add contacts then the moment someone starts typing their name it will work, but that might mean they see contacts in the list they shouldn't. If it doesn't matter, try that.
Or the option is to use data shuttle so that when you add a name, you can run the transfer of those names into the list.
Let me know if that works
thanks
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 460 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives