How do you limit items in a dropdown menu field based on the selection of another?

Tony Fronza

We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example:

We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to only jobs related to the Department selected.

Can this be done using a helper column or a separate sheet/table?

Any help is greatly appreciated!

Kleerfyre

You could do this with a form within the sheet. Forms have conditional logic built into them for this type of situation.

Tony Fronza

Sorry, I should have clarified that I knew the form logic. But, is there any way to do this in the sheet/grid?

M.Graper

Hello,

I'm also curious if this is possible, with a similar issue with Functional Group & Subgroups. Is there a way to apply this sort of logic to a Sheet rather than in a Form? Perhaps through a formula?

Please let me know.