Achieve Dynamic Dropdown Lists in Smartsheet

The ability to better manipulate Dropdown Lists is  a popular request from our Smartsheet clients.

Our solutions satisfy two very different requirements which can be simplified as follows

Smarter Dropdown List Manager

A solution for updating data values held in one master dropdown list which then automagically updates matching dropdown lists in other nominated Smartsheets.

When these dropdown lists are updated, Smartsheet forms automagically pick up these revised dropdown lists and so add considerably to the power of the forms.

We are supplying this solution to existing clients right now for a small extra cost using API coding and a nice easy Smartsheet interface. Simple to use and very powerful.

Conditional Logic for Dropdown Lists

Is where the need is for Conditional Logic… meaning when using a SmartForm,  the selection offered at each level changes according to your previous selection. Also not possible in native Smartsheet forms.

This solution behaves more like a database although the resultant “Conditional Logic” activity can be entered into Smartsheet for action. We achieve this for clients by providing a Web Form link which offers the relevant choices and selections, concluding in some form of action. To do this we use Appsheet with Smartsheet and it works really well to achieve fairly simple or very complex solutions.

See our full range of Smarter App Solutions

Arrange your Free Initial Consultation to review your Team App requirements – we’d love to hear from you.