Update Smartsheet Dropdown List from Another Sheet
Smartsheet add-on to update Smartsheet contact column and dropdown lists from another sheet!
Do any of these sound familiar to you as a Smartsheet user?
- You have built the perfect Smartsheet complete with contact and dropdown lists with all of the needed values. It’s so good that all of your colleagues have been copying your sheet and using it for their projects. There’s just one problem. There’s no easy way to keep all of the contact and dropdown lists updated with the most current selection values.
- You have an export of the company directory in Smartsheet, and would like to keep contact lists up to date as employees are hired or leave the company. Furthermore, you would like to include employees in specific contact lists based on their job role.
- Ever wanted to update the values of a Smartsheet dropdown list from another sheet?
- How about automatically updating a Smartsheet contact list or Smartsheet dropdown list from another sheet?
What's the Solution?
The Smarter Dropdown List Manager! Smartsheet Guru is happy to be partnered with Smarter Business Processes as a reseller to offer this solution.
What Smartsheet plan is required to use the Dropdown List Manager?
Business and Enterprise. The Smartsheet Dropdown List Manger utilizes Smartsheet’s API and both the Business and Enterprise Smartsheet plans allow generating an API token. Unfortunately, the Smartsheet Pro plan does not allow users to generate API tokens.
I have Smartsheet Control Center, is the solution still useful for me?
Yes! With Smarthseet control center you can apply global updates to update the values in dropdown lists. However, Control Center can only update sheets that have been created with Control Center. Furthermore, global updates are still manual in the sense that you have to manually input the selections to be updated. With the Dropdown List Manager, contact and dropdown lists will update automatically when the source sheet or report is updated.
What is required to implement this solution?
We’ll have a free consultation to discuss if this solution is right for you and how it will be implemented into your Smartsheet environment. From there you’ll provide the required information about your Smartsheet account and the add-on will be setup for you!
Use the button below to book your consultation!
Can I see a demo of this solution?
Yes! See the video below for a demonstration and further explanation of the solution.