Check boxes to search on a sheet

Stevefc · 09/13/19

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å · 09/13/19

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, andree@getdone.se)

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome · 09/13/19

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 · 09/16/19

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å · 09/18/19

Glad we got it working!

Have a fantastic week!

Best,

Andrée

Check boxes to search on a sheet

Comments

Categories