Dynamic drop-down options based on a selection in another column?

gjohnson.pcpro

Hello!

I have a "Client" drop-down box with 50 options. For simplicity's sake I'm just going to pretend these are values of 1 through 50.

Many of the values in the drop-down are only relevant to certain teams based on their geographical location. If possible, I would like to only show the relevant options based on the selection each user makes in a separate "Region" column.

For example, if "North America" is chosen as the region, only options 1-15 would be visible in the "Client" drop-down. If "EU" is chosen as the region, only options 16-40 would be visible. If "UK" is chosen as the region, only options 41-50 would be visible.

Is it possible to achieve this via automation or formula?

Ray Lindstrom

Natively in Smartsheet you cannot dynamically change dropdown values based on selections made in other columns.

Formulas would prevent users from being able to manually populate the field(s).

Automation would require a Save to the sheet before triggering anything which would help if a user is tabbing across the grid and entering/selecting values.