on 2025 Jan 24 6:46 PM
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 |
|---|---|
| 7 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.