2 weeks ago
Hello, I am using a parameter that is linked to a calculated field as a search bar. The problem I am having is that when I'm searching for a very specific item, it's returning too many unrelated results because of the letters involved. For instance, I have a show title that I'm searching for called 'ION'. When I perform the search, it is returning every word in all of my concatenated data sources containing those letters. Is there a way to narrow the search so all of the other values containing those letters do not show up? I've posted a sample excel file and my calculated field below for viewing. The green entry is my targeted search, the yellow highlighted ones are all what is added when I search 'ION' directly. Thank you as always!
CONTAINS(([SHOW NAME]),([Search Parameter]))
or
CONTAINS(([PASSWORDS]),([Search Parameter]))
or
CONTAINS(([POINT OF CONTACTS]),([Search Parameter]))
Request clarification before answering.
User | Count |
---|---|
48 | |
9 | |
8 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.