Forum Discussion
Filter Function Data Linking
I am using the filter function below to take all jobs "Won" from my main data sheet. Columns (B-P) are a part of the Filter function, I want to keep track of the dates I send the invoice to the clien...
I have found that this function works well and should solve your issue, however the one thing it doesn't do is make hyperlinked data remain as a hyperlink, that's something I'm trying to resolve. So your data would be in a tab that I'm calling Data[Employee ID2] the Data is the name of the tab while the Employee ID2 is the column label.
=FILTER(Data,ISNUMBER(SEARCH($B$3,Data[Employee ID2]))=TRUE,"Not match found")