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] <> "")
Try with SELECT(Components received[collection_cup_lot_number],true) - LIST("")
Hi @AleksiAlkio thank you! I am afraid that didn't seem to change it.
@AleksiAlkio - I found a work around using your "-List()" suggestion.
I auto-filled the blanks with "N/A"
Then added -List("N/A") to my original formula.
Final formula: SELECT(Components received[collection_cup_lot_number],true) - LIST("N/A")
Final view:
Thanks so much for the help!
@AleksiAlkio For the past month or so, the `- LIST("")` thing hasn't been working. Have you noticed this?
Stumbling across this myself. @AleksiAlkio any insight?
How about:
SELECT(Components received[collection_cup_lot_number], [collection_cup_lot_number] <> "")
Thanks @romulo_torres this worked - and saved the work around I posted above.
Final view:
Do you know why I am getting the yellow '!'?
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |