Dependent dropdown with condition

[Sheryl_Wang]

Hi,

I would want to have a dependent dropdown for my items which references to another worksheet in Google Sheet but also to only show those that have the status of “Available” only.
Any suggestions on carrying out this?

For e.g.
Fruit & Vegetable items: Apple, Peach, Mango, Carrots, Cabbage
Status: Available, New, Sold
Inputs: Apple (available), Peach(sold), Mango(new), Carrots(new), Cabbage(sold)
If choose Fruits, the dropdown will show: Apple (available)
If choose Vegetable, the dropdown will show: -Nothing-

*As I want to prevent users from selecting and viewing those “New” and “Sold” items in the dropdown.

Thank you!

[Steve]

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.

help.appsheet.com

List Expressions

List expressions use and/or produce lists of values.

[Sheryl_Wang]

Hi Steve,

Thanks for your suggestion! But I have tried it and it does not work well for my app.
Instead, I found out that I am able to use slice function and dependent dropdown referencing method to carry out.
I created a slice (Available Items) which consists of only those items with “Available” status. Followed by using the dependent dropdown method, which is to input “Available items[Name of Item]” as seen in the picture in Valid If.

Thanks anyway!