Dependant Dropdown

[Dan_Oliphant]

I am trying to scan in orders from a set of data called, client_inventory. I am scanning in the orders using a separate spreadsheet.

I am trying to create a slice that I can use in the Valid IF statement so it will eliminate the items already scanned.

Is there a way to create a SELECT statement that can look if the value exists in another table?

[Rafael_ANEIC-PY]

Hello @Dan_Oliphant , yes, you can use list expressions for that purpose:

help.appsheet.com

List Expressions

List expressions use and/or produce lists of values.

help.appsheet.com

List Subtraction

Subtract lists to produce another containing only the unique items of the first list that aren't also in the second.