Populating Dropdown Menus using Conditional Logic in Forms

Gina Smith

Hello,

We are now using Data Shuttle to populate values within a dropdown menu of other sheets. Is there a way to also use Data Shuttle to populate 'different' dropdown options in the same column based on the conditional logic within a form.

For example, say we have 20 educational partners and each partner has anywhere from 15-25 course codes for a given program. We can now use one input sheet from the Project Management team to track course code changes and we can use Data Shuttle to update those dropdown values in one column of a shared sheet. However, I don't want one DNS (who is inputting data into the sheet) to have to scroll through all partner's course codes to find their own course codes. If I have them input the data through a form and they enter their partner name, could the values in the course dropdown column 'vary' depending on the partner name they enter? This would allow them to see only their own courses?

Thanks,

Gina

Andrée Starå

Hi @Gina Smith

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

• Add one column for each partner and use the Form Logic to show the correct one in the form.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Abby Patterson

Hi @Andrée Starå ,

Following up from your response above - is there any way to prevent all the columns showing in the Smartsheet though, after adding one for each conditional logic response/dropdown? I just would like to prevent having multiple empty columns and making the sheet lengthy. Can conditional logic in the form help populate only columns/fields that contain data?