Google Sheets Tips

List if the website is included.

• =ARRAYFORMULA(IF( ISNUMBER(FIND("example.com", A2:A)), "Yes", "No"))

Now Filter Views can be used on that boolean column to only display rows that match.

A	B
URL	Internal Domain?
example.com	=ARRAYFORMULA(IF( ISNUMBER(FIND("example.com", A2:A)), "Yes", "No"))
otherwebsite

---

Filter in one list and not another.

• =filter('sheet_1'!A:A,isna(match('sheet_1'!A:A,'sheet_2'!A:A,0)))

--

Filter out one column based on the value of another.

A	B
TRUE	A
FALSE	B

• =filter(B1:B, A1:A=TRUE)

Shows all values of B where column A is TRUE.