Limit List Options

[cmunson]

I’m trying to figure out a way to limit options in column 2 based and answer given in column 1. Think of it as manufacturer/model situation. Column one user selects manufacture column to automatically limits options to models from that manufacturer.

I’ve created a reference sheet that lists the manufacturers in column 1 and the models in separate columns based on manufacturer.

Not sure what type of “Valid_If” equation to use. Or even if this is the right process.

Basic example. Uses selects Ford. the next option would be limited to only Ford models.

Thanks in advance

[Suvrutt_Gurjar · Accepted solution]

Hi @cmunson,

Welcome to AppSheet community!

Could you take a look at following sample app and article on concept of depedent dropdowns

Article : https://help.appsheet.com/en/articles/961554-dependent-dropdown

Sample App:
https://www.appsheet.com/samples/How-to-create-a-dropdown-menu-with-values-that-depend-on-earlier-ch...

[cmunson]

Perfect. Thank You!

[Stevo_Kerr]

Short Answer:

Data > Column > {Your_table}

Manufacturer column:
Pencil icon > Data Validity > Valid If: {Your_table}[Manufacturer]

Model Column:
Pencil icon > Data Validity > Valid If: {Your_table}[Model]