Hi all, kinldy see below in the color pick up list.
It says "Add or search". How can I only allow users to search not to add and can I change it "Search" and not "Add or search" text.
Thanks indeed.
For allow users to search Name_Table[Color]
Also you can use LIST LIST("Blue","Red","Yellow","Green")
Thank you very much
what I wanted exactly is that when a user searches for a color - I want to let him/her only see the available list of colors without the option to add a new one:
see image below plz:
You will get what you are looking for if you try these formulas. within ( valid if )
Name_Table[Color]
or
LIST("Blue","Red","Yellow","Green")
User | Count |
---|---|
42 | |
29 | |
28 | |
14 | |
14 |