Hello!
I am struggling to remove blanks from suggested values (see image of what appears in a form).
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! Go to Solution.
How about:
SELECT(Components received[collection_cup_lot_number], [collection_cup_lot_number] <> "")
User | Count |
---|---|
24 | |
15 | |
4 | |
3 | |
3 |