Help with two Filters

[jbrines]

Hi All,

I have the following filter on a Gallery

Filter(Vistors,'Sign In Date and Time '>= Today())

I want to add another filter where it will also show only blank entries in the "Sign Out Date and Time " list column "Visitors"

Thanks

John.

[CNT]

@jbrines Try this,

Filter(Vistors, IsBlank('Sign In Date and Time'))

[jbrines]

Thanks but I want to keep the Sign Date and time as it is and add another filter for Sign Out.

[C-Papa]

Hi, i would add a button somewhere and change the OnSelect to: Set(var_show_Blanks,!var_show_Blanks)

Then for your gallery / collection items:

If(var_show_Blanks,
Filter(Vistors,IsBlank('Sign Out Date and Time ')),
Filter(Vistors,'Sign In Date and Time '>= Today()))

[CNT]

@jbrines Then try this,

Filter(Vistors,'Sign In Date and Time'>= Today() && IsBlank('Sign Out Date and Time'))
)

[jbrines]

I get a delegation error with this formula.

[jbrines]

@CNT I get a delegation error with that formula.

[C-Papa · Accepted solution]

try using the below to avoid delegation

Filter(Vistors,'Sign In Date and Time'>= Today() && 'Sign Out Date and Time' = Blank())

[jbrines]

@C-Papa  Many thanks.