Limit Dropdown Options Based on Cell

Charlesdavid Allen

If there is a quality answer to this someone can point me to, feel free to link it. I've searched but find none other than that this has been requested for some time.

Here is the setup:

I have a dropdown with "Stage"; It has the following Values and is limited to one of these values.

I have another Column for "Status"; Each of these stages has a number of status types:

When Selection in Column:Stage is selected, I want to limit the dropdown options in Column:Status to only those status values appropriate to the stage.

I've placed the Stage and Status values in another table, and attempted to do this like I would in excel by setting the Status to Dropdown, and using an Index to select the appropriate column in the second table based on the value of Stage; Smartsheets Index() has a row requirement but an optional Column, so I also tried this using the data in a horizontal configuration (1 row per state with status options).

I've attempted various forms of INDEX(COLLECT()), INDEX(), INDEX(MATCH())

Any assistance would be greatly appreciated.

Andrée Starå

Hi @Charlesdavid Allen

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

• Use a form instead combined with Conditional logic
• Add multiple columns in the sheet and color code and use formulas to guide the user where to go next.

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!

Andrée Starå

Hi @Charlesdavid Allen

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

• Use a form instead combined with Conditional logic
• Add multiple columns in the sheet and color code and use formulas to guide the user where to go next.

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!

Charlesdavid Allen

@Andrée Starå - Thank you for your response, unfortunately the suggested workaround will not suffice in this situation.

Unfortunately it appears from my research in the community that this has been requested for years and has not been completed.

Andrée Starå

@Charlesdavid Allen

You're more than welcome!

Yes, I also hope it will come because it would be a game-changer for sure.

BarbaraHanville

@Charlesdavid Allen Do you know if this has been implemented? I need the exact same functionality. If you have submitted an Enhancement Request, please send me a link so I can vote on it. Thanks!