Contact lists and Contact groups. Is there a way to import contacts from the contacts list?

Graham Rimell

Our business has a few hundred Employees split up into different areas and groups.

As part of our various smartsheets project we have a form with a row that has a drop down menu for name, with everyone in the business listed. I want to add various groups of employees to a contact cell, sometimes the entire contact list of employees!

However this is a very manual task that requires me to go through a list from A to Z. This would be fine if I was adding 10 people, but I'm trying to add about 300 people. Spending an hour manually doing this is pretty awful, and not reliable as there's no easy way to ensure you don't accidentally miss a person.

The contact list and a group that has everyone in it, but there seems to be no way to simply say 'Import all from group'.

This simple functionality would save us hours.

Is there any workarounds to allow us to do this?

Thanks!

David Tutwiler

Yes. If you have that list in either:

1) A Smartsheet Attachment

2) Google Sheet on Google Drive

3) Document in One Drive

then you can use Data Uploader to schedule an import into a drop down list at regular intervals. So, if you attach this list to the Smartsheet that you want to use this for, then you can set up a schedule that says, "Go check this attachment to see if it has changed and update my drop down accordingly" every week/day/hour depending on your requirements.