Dropdown List Alternative with Automatic List Update and Dynamic List Features

jmyzk_cloudsmart_jp

There have been many requests for improvements to the Dropdown list from Smartsheet Community.

The two most typical requests are

• Automatic updating of the list @Justin Mauzy @Taylor Compton - NOAA Federal
• Dynamically changing the list of the following selections based on previous selections @Ian Cooper @Mehran Bagherian

Regarding the first automatic updating of the list, users want a master sheet of dropdown lists, so changing the list will change the options on the target sheet's dropdown lists. Since this functionality is unavailable, the user must manually update the list.

As for the second, dynamically changing the list of the following selections based on previous selections,  some mimic dynamic or dependent dropdown lists, using form logic to display a specific column of choices based on the previous selections, preparing columns for the options in advance. However, this method also requires manual preparation of the columns of choices and works only for the form.

To solve this problem, we have devised a workaround that displays a list of two-digit numeric IDs and dropdown list items in a cell so that users can enter the two-digit numeric IDs corresponding to a list item.

Although it is not as easy as a dropdown list, where you can click on a choice and the selection is complete, our method only requires you to enter a two-digit number, so it is not much of a hassle. You can prepare the two-digit number choices and have the user click on them.

To try this solution, please refer to the sample dashboard in the following link.

https://app.smartsheet.com/b/publish?EQBCT=2580af6de6e845758f74b6556396d9ee

For more information, please refer to our homepage article and Youtube video in the following links.

https://cloudsmart.jp/smartsheet/templates/dropdown-list-alternative-with-automatic-list-update-and-dynamic-list-features/

https://youtu.be/IbZdlPTzN-k

jmyzk_cloudsmart_jp

Here is another "Dropdown List Alternative"

I came up with this alternative answering Jadon's "Formula as an alternative to Dynamic dropdown menus?" question.

With this method, you can narrow down candidate pairs of the "Code: Value" list by inputting part of the list's value.

https://community.smartsheet.com/discussion/comment/380420#Comment_380420

jmyzk_cloudsmart_jp

If you need to access the demo contents, please complete the following form;

https://app.smartsheet.com/b/form/c06619d504f9418284b4125eec205a54

(We create a copy of the contents folder and share the contents in the folder. Note: We can not share the folder.)

jmyzk_cloudsmart_jp

Please select "Dropdown List From Another Sheet: Template"