Conditional Drop-down lists based on another column or field

I am looking to create a conditional drop-down list for a column based off the value in another column. For instance I have a column called Type (Product, Customer, Technology, etc...). Each Type will have its own Categories...

Product (Print, Digital, Service)

Customer (Private, Public, Government)

Technology (HMTL, PHP, Python, SQL)

If I select Type: Product I only want to see categories related to Product, Customer = Customer categories, etc...

paul e. reeves

Principal Business Analyst

HMH

Best Answer

  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭
    Answer ✓

    I am not sure how to do this so I would be interested to hear if there is a way to do it as well.

    I have just had a separate column for each dropdown list and then used the join function to bring it all into one. In the form you can use conditional formatting to only show the correct drop down column based on the first category.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!