I am trying to achieve a result using an Suggested_Values Request, to make a drop down menu to display only my [part_serials] that have these conditions [part_condition] = “GOOD” & [part_location_email] = USEREMAIL(). When I try to do this it just shows the dropdown as blank, I still need the user to be able to add their own serial if needed.
This is what I’m trying to do ATM:
SELECT(parts_index[part_serial], [part_condition] = “GOOD”, [part_location_email] = USEREMAIL()).
All help is much appriacted.