Conditional Logic on Smartsheet Forms
Good news for Chrome and Firefox users – we have created a solution for Conditional Logic on Smartsheet Forms by using a FREE to download and use extension.
Go here to download the relevant extension – (scroll down to Smarter Smartsheet for Chrome or Firefox buttons)
We are working on other Browsers like IE and Safari but not there yet and will announce it when we can.
Our API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps but one request we have been unable to fulfill up to now (unless we use Appsheet with Smartsheet) is the need for Conditional logic aka Cascading Dropdowns, when completing forms in Smartsheet.
What Pain are we resolving?
In many apps like Excel, Google Sheets or Access, Forms can be produced where by Form Completers choose from the initial dropdown list, then the choices for the second question change accordingly, when that question is answered the next choice is similarly filtered and so on. Then the resultant data is entered into a smartsheet for further actions to commence.
How have we resolved this pain?
By running our downloadable extension and then using a naming convention for the Dropdown List columns, users will be able to experience conditional logic between the columns.
Your company car list allows you to choose from a range of cars.
Q1 What Make? Bentley or Jaguar
Q2 Which Model from the chosen makers list only
Q3 Which Engine from the list applicable to the choice made for Make and Model
Final selection goes to Smartsheet for your order to be processed.
What naming convention is required?
In order for this extension to work, you will need to name your columns and set up the dropdown list values in a specific way. Each tier in the logic needs a prefixed reference to the previous tier linked by a dash.
In the example scenario above we have 3 dropdown columns in play, one for each question, e.g. Make, Model and Engine. For the logic to work we would have to rename the columns in this way: Make, Make-Model, Make-Model-Engine. The data contained within the dropdown lists would also follow the same convention e.g. The values for the Make column would be: Bentley, Jaguar. The values for the Make-Model column would be Bentley-M1, Bentley-M2, Jaguar-TypeS, Jaguar-TypeE. The values for the Make-Model-Engine column would be Bentley-M1-V6, Bentley-M1-V12, Bentley-M2-V6, Bentley-M2-V12, Jaguar-TypeS-V6, Jaguar-TypeS-V12,Jaguar-TypeE-V6, Jaguar-TypeE-V12
Why is this solution Free?
Because we know it is not a complete solution as it only works on machines using Chrome or Firefox so users of other browsers cannot benefit yet. So, it is free for those that can benefit.
In the meantime we continue our research to provide this solution for everyone in an even Smarter way if we can.
See this solution working?
Click link to the SmartForm
Click link to the Form Data Landing Sheet
For clients seeking API integrations and automations for their company either bespoke or from our range of Smarter Mini Control Center solutions, please contact us – we’d love to hear from you.