Solved: Search Form Expression Issue - Page 2

Jon_Marchand · 02-10-2021 01:44 PM

I have this expression below. I am trying to use the same field input from a search form to filter the same spreadsheet by two separate columns . For whatever reason, when I add the second expression the search results fail. Is there anything that looks suspect in this that would cause this to happen? The first expression (highlighted in yellow) works by itself but when I add the second expression (highlighted in red) it fails. The syntax is not the issue because it passes. Please let me know if there is something amiss in my expression.

Marc_Dillon

Well you didn’t say that!

Assuming [Formatted_Session…] values match exactly with [Session(s)] values:

AND(
  OR( ISBLANK(...) , IN( [Formatted_Sessions1] , [_THISROW].[Sessions] ) , IN( [Formatted_Sessions2] , [_THISROW].[Sessions] ) )
)

If they don’t match exactly, ummm… you’ll probably need a lot more complex expression, or you’ll be out of luck, or only allow a single selection (Enum instead of EnumList), and go back to CONTAINS().

View solution in original post