Forum Discussion
Search bar - if blank, show nothing
GustavJ
1. "I'd like the results to be empty if the search bar is empty."
>Try:
=IF(I3="", "", FILTER(Contactlist, ISNUMBER(SEARCH(I3, Contactlist[System/funktion])) + ISNUMBER(SEARCH(I3, Contactlist[Namn])) + ISNUMBER(SEARCH(I3, Contactlist[Kommentar]))))
2. "Also, since this is a contactlist, is it possible that the searchresults make the email links clickable? As in if i click the email, it starts up the mailto function pretty much as it would in a normal table."
> Excel native filtering doesn't directly support hyperlinking, but there's a workaround using a helper column.
Add a new column (let’s call it “Email Link”) next to your existing data.
- In each row of the “Email Link” column, create a hyperlink using the HYPERLINK function. For example:
=HYPERLINK("mailto:" & [@[Email]], [@[Email]])
Replace the [@Email]] with your cell reference to your email address on the contact list.
Alright, i think i got both the IF formula to work, as well as the hyperlink (icon in my case).
Now it looks like this:
At the moment i have to show the mail icon to every row, even if it does not contain a search result. Can i somehow hide those icons if that specific row does not have a result?