Hi,
Is there a way to restrict the options in a dropdown list based on the content of another column?
e.g. column 1 (status column) can be car, truck, moped and i want the options in the dropdown in column B to change depending on what they pick so if column A = Car then Column B = Red, White, Green but if column A = moped then column b = Orange, blue
thanks
Kat
I would also love to know if this is possible. My company uses semi-formulaic series of dropdowns (A1 + B1 = C1, A2 + B2 or B3 = C2 …)
To minimize input error, it would be really helpful to have this ability. Automations can somewhat handle my use case, but not exactly in a scalable/easily maintainable way.
Hey Kat! Looks like we can add some formula to the columns to get this done.
hey, amazing! can you show me what that formula would be?
thanks!
Hey Sure! What’s the best place to get in touch?
can’t you just post it on here?
Hey Kat! My apologies for the delayed response.
I confirmed this with my team members, so using a formula is the best case scenario if you already know when an answer will be blue, and when it would be white etc. Meaning, formula can only work if we can calculate a single answer.
What we can do here is to split your column B into multiple columns, such that one column could be for red, white, green and none, and another column for Orange, blue, etc
Also interested in a conditional list based on another columns selections. The proposed solution of several columns doesn’t seem like a great solution.
Muhammed, i have this same issue. the need for conditional list based on another column selection seems to be a recurring issue to which monday.com has offered no viable solution. at least not one that can easily be found. can you offer any information as to whether or not this is being looked at?
Whats the status on this? A formula and multiple columns is not the answer. Is monday working on this?
Hello,
I’m happy to share that this is now possible in our Column Changes Guard app.
You can display only some dropdown options based on other columns and who is changing the column. Here is a quick set up:
Install the Column Changes Guard app
Add a “Dropdown - Dynamic Options” column (Add column > More column > Installed Apps section)
Create options and configure their visibility based on different conditions and permissions (as a board owner or an admin)
See only allowed options based on configuration (as a user)
If you have questions or use cases that aren’t cover, please let us know!
That’s such a good idea having dropdowns change based on another column would make things so much easier and way less messy. I’ve spent too much time trying to fix random mismatched entries, so this would be a game changer. Also, I’ve been trying to make my workspace a bit more fun lately I added a small neon sign from and it actually makes those long setup sessions feel a lot more chill.
