Removing blanks from suggested values

Hello! 

I am struggling to remove blanks from suggested values (see image of what appears in a form).

JEast1993_0-1708517302174.png

The suggested value formula is: SELECT(Components received[collection_cup_lot_number],true)

There are multiple components in the "Components received" table and each component has its own lot number column. This is so in the form above (for assembling an order) I can then select a lot number for each component in that order. 

Ideally in the example above I would only be able to see the collection_cup_lot_numbers and have blank buttons.

Thanks in advance

 

Solved Solved
0 7 243
1 ACCEPTED SOLUTION

How about:

SELECT(Components received[collection_cup_lot_number], [collection_cup_lot_number] <> "")

View solution in original post

7 REPLIES 7
Top Labels in this Space