Formula

[elboga81]

Hi there
I have a problem with Appsheet
I want to filter a name in 4 columns. I have this formula:
LINKTOFILTEREDVIEW("Player Fixtures", ([PLAYER] = [HOME A]) OR ([PLAYER] = [AWAY A]) OR ([PLAYER] = [HOME B]) OR ([PLAYER] = [AWAY B]))

But only filters if the name is in the 1st Column, if the name is in any other columns it just doesnt work.
But if i use a single filter in any other column it works fine.

Example:
LINKTOFILTEREDVIEW("Player Fixtures", [PLAYER] = [AWAY A])
Then it does, search for the right column
Hope someone can help me
Thank you so much

[1minManager · Accepted solution]

LINKTOFILTEREDVIEW("Player Fixtures",OR([PLAYER]=[HOME A],[PLAYER]=[AWAY A],[PLAYER]=[HOME B],[PLAYER]=[AWAY B]),TRUE)

https://support.google.com/appsheet/answer/10107338?hl=en&sjid=401753020200998670-EU

Simon, 1minManager.com