Dropdown Column determines second dropdown column contents

James Emge

HI All - thank you for any help on this. I have a form entry and in the first column drop down I have choices A,B, and C. Now for a second dropdown column, If I choose A in hte first column, in the second column dropdown I want to see choice 1,23. If I choose B in the first column, I want to see North, East, South, West. and so on.

Any ideas if this is possible and if so how? thanks!

Andrée Starå

Hi @James Emge

I hope you're well and safe!

As a possible workaround, you could use a form and the conditional logic feature.

More info: 

Use Conditional Logic to Streamline Form Submissions | Smartsheet Learning Center

https://help.smartsheet.com/articles/2481701-use-conditional-logic-to-streamline-form-submissions

With conditional logic in forms, you can ensure that people using the form will only answer the questions that are relevant to their submission by

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Heather Duff

Hi James,

When people enter the data, are they entering it directly in the sheet, or are they using a form?

Thanks,

Heather

Andrée Starå

Hi @James Emge

I hope you're well and safe!

As a possible workaround, you could use a form and the conditional logic feature.

More info: 

Use Conditional Logic to Streamline Form Submissions | Smartsheet Learning Center

https://help.smartsheet.com/articles/2481701-use-conditional-logic-to-streamline-form-submissions

With conditional logic in forms, you can ensure that people using the form will only answer the questions that are relevant to their submission by

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

James Emge

Thanks Andree, that is what i was looking for.

Andrée Starå

@James Emge

Excellent!

You're more than welcome!