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


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
    Kleerfyre ✭✭✭✭✭✭

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

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

  • Tony Fronza
    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


    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!