I’m trying to create a dynamic dropdown column where the available options depend on the selection in another column.
For example, I have a Category column with options like Fruits, Berries, and Veggies. Based on the selected category, I want the Sub-Category dropdown to display context-specific options — e.g., if Fruits is selected, then apple, pear, and peach should appear as sub-category choices.
Is this functionality currently supported? I came across a thread from 2021 stating it wasn’t possible back then, but I’m hoping there have been updates since.
As is, that’s not available. However, could be done with some workarounds. Which product (CRM/Work Management, etc) and level (Pro/Enterprise) do you have?
Hiya, what is your intended use of the sub-select?
You could create a new board called “Veggies”. The rows would be the parent veggie, then have a text column with the sub-item options. The parent Item would be listed multiple times. On the main board do a connect board to the new board and mirror the text column.
You’ll have to select the correct parent Item (it’ll appear multiple times) but you’ll have the sub-select in a new mirror column.
If you can tell me more about what you want the sub-select to be used for I may be able to adjust.
Another option is have a formula column with a complex if/than/switch formula. It would display a red X emoji if the pairing wasn’t acceptable and a green check if it was. This check formula could then be used in filters or formulas where the sub-select is needed. It wouldn’t prevent people from selecting the incorrect option, but would prevent bad logic from continuing down your process.
I am trying to recreate an excel I have, in which I use dynamic dependent columns. For example, if I choose fruits in column A, then column B dropdown options should only have apples, bananas etc as options. If I choose vegetables in column A, then column B dropdown should have carrots, potatoes etc as its options.
I understand that conceptually, but are the drop downs just visual information for when you look at the board, or are they used in more complex logic and processes, or reporting and dashboards, etc.
Hello @Srishti This is doable in monday though it’s a little different from how Excel handles dependent dropdowns.
monday doesn’t currently support true dynamic dropdowns where the options in one column automatically change based on another column’s value. That said there are a couple of practical ways to get very close to the same behavior.
The most common setup is to use two Status or Dropdown columns. Column A would be your category like Fruits or Vegetables and Column B would contain all possible options. You can then use automations to clear or reset Column B whenever Column A changes so users are nudged to pick the correct value for that category.
Another cleaner workaround is to split the second column into two separate columns such as Fruit Type and Vegetable Type. Based on what’s selected in Column A you can show the relevant column and hide the other one using automations. This keeps data clean and avoids incorrect selections.
If this is being filled out through a monday Form it’s even easier since forms support conditional logic. Selecting Fruits can show a fruit dropdown and selecting Vegetables can show a vegetable dropdown automatically.
If you want to share how you’re entering the data and where it’s being used I’m happy to suggest the simplest setup for your use case.
Dr. Tanvi Sachar
Monday Certified Partner, Monday Wizard
Hi Michael, this board is to be used as a way for various people to add requests so I need logic based columns that will change based on the option chosen in columns prior. Based on Dr. Tanvi’s below, think creating a form might be the best way forward.