Check boxes to search on a sheet

Stevefc

I’m trying to use check boxes to search on a sheet. Is it possible to show or hide rows based on a check box entry? Regards Steve 

Andrée Starå

Hi Steve,

Interesting!

I'd say yes but it depends.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

To show or hide rows based on a checkbox, I would say you have two options. Either you can pull a report based on that checkbox, or you can create a filter based on that checkbox.

Stevefc

Hi Andree

I’m trying to filter the account manager against projects allocated to them. I’ve added a formula in the Filter Match column to check boxes for projects against the account manager in the drop-down list showing in the ‘Select Name Below’ entry. When you select ALL in the ‘Select Name Below’ the check boxes are reset.  What I would like to do is only show the rows that are checked against an account manager and reset to show all. Hope this helps, 

Regards

Steve 

Andrée Starå

Glad we got it working!

Have a fantastic week!

Best,

Andrée