Forum Discussion
Solved
Search Box Formula
Hi, Can anyone help me out with this very basic scenario involving a search box. I have added a snippet but cannot understand why its not filtering when trying to search "Advisor Name". ...
Amazing Patrick. That worked perfectly.
What is the significance of "ISNUMBER" in the Syntaxx
Thanks Again
What is the significance of "ISNUMBER" in the Syntaxx
Thanks Again
Although your data is partially redacted, my guess was your original FILTER did not pull the record because "Saif" was in the advisor column, but "Saif" wasn't the only thing in the column. If SEARCH is successful, it returns a number. When SEARCH fails, it returns #VALUE! error. Does the result of SEARCH produce a number? When it does, FILTER pulls the record.
- Thank you, thats makes sense. If i understand you correctly, previously searching "advisor name" would not bring any details/errors-just stayed blank.
The only problem I am facing right now is if i leave the search box empty it shows all the data blow- any way to stop from all the data showing?=IF(ISBLANK(H2),"",FILTER(Gradbay,ISNUMBER(SEARCH(H2,Gradbay[Advisor Name])),"No Record"))