Toggle a filter when any selection is made

[#1]

Hi all,

I am hoping this is a simple trigger that I am missing. Basically my sheet right now has about 15 options the user can select from, with many choices per selection. There are 4 multi boxes with 3-4 dimensions in each box with many choices per dimension.

I have a Current Selections Box in the upper right to show the users their current filters.

When a user opens the program, I would like a text box to say something like "No Filters Selected." Then if the user selects anything, the box should say "Number of Records with current filters: x" I already wrote the expression count based on number of rows to change x to a real number.

So is there a way to do this? My thought is to change what a variable says when something is selected?

Thanks so much.

[MayilVahanan · Accepted solution]

HI

Try like this in text box:

=if(Len(GetCurrentSelections())=0,'No Filters Selected','Number of selections selected '&your expression)

[#3]

Thanks, that worked perfectly!

[#4]

Hi, can you please provide your expression to get the no if rows chnaged with current selections?

[#5]

Here's my expression in full:

=if(len(GetCurrentSelections())=0,'No Filters Selected: '&num(count([Account #]),'##,###')&' total records',

'Number of Records with current filters: '&num(count(Account #]),'##,###'))