Is there a way to optimize drop down menus?

hello i am trying to have certain values only show when someone chooses one value.

here's an example:

Entity 1

Entity 2

Entity 3

Now based on those three entity there would be a seperate drop down menu with 10 items:

Item 1

item 2

item 3

item 4


But if i choose entity 1 then only item 2 and 7 show but if i choose entity 2 then only 2, 4, 5, and 9 would show. I would want this to be used in the form as well so when someone fills the form out and they choose entity 2 in the drop down then in the next drop down they only have the option of item 2, 4, 5, and 9.

The reason for this is because I have multiple entity and I want an address attachted to them without having people fill it in manually but the only probalme with that is one entity name might have 10 different address attached the the entity name. so I want them to have the option to choose from only 10 addresses rather than 100. Is there a way to do this with automation, a formula, or even when I edit a form?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!