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
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives