Dropdown with select()

[Shafeq_Ahmad]

What I am trying to do here is adding a dropdown (“Avl Qty” in sheet QTY Sheet).

I have added under valid if "QTY Sheet[Avl Qty]" in Units and entire column details pulls in dropdown.
Instead of only for apple product where the qty is 1,2,3,4,5,6&7.

[Chris_Jeal]

Perhaps try in your valid if field,

Select(
QTY Sheet[Avl Qty],
[Product]=[_THISROW].[Product])

Or if you haven’t a product selection and just want to search apples then just replace [_THISROW].[Product] with the product name.

C

[Shafeq_Ahmad]

Thank you for taking time to look into my app.

[Steve]

help.appsheet.com

Dependent Dropdown

How to make a dropdown with choices that depend on the value selected in another dropdown.