Filter formula to filter if control checkboxes are checked

[Brittany_Gelbart]

I have some control checkboxes (lets call them checkbox 1, checkbox 2, etc) and I want them to apply filters to a specific column (Columnb B) in a table when those boxes are checked. If no boxes are checked, I want all of the filters to be removed for that column. I can’t seem to find any definitive answer to this in the available documentation. Thanks!

Doc link below. I am starting with just 2 checkbox controls for now. I’ll add the rest of the controls once they start working…

Alternatively, I would be open to accomplishing the same goal with control buttons but I couldn’t get that to work either, even when linked with a dropdown control filter.

[Pablo_DV]

Hi Brittany,

Welcome to the community!

It would be much easier to help you if you would share a doc with what you tried so far.

Guide: How to share a doc with the Coda Community

TL;DR Guide for new Coda-Users: How to share a doc with the Coda Community. Copy and paste it into all topics where there is insufficient information. Long version: Hello folks, This is my first post in this category. I don’t think this post has much added value, but I decided to publish it here anyway. In the last months, I have often seen that new users, in particular, need help, but are not aware that it is extremely important for us to share their document, add a screenshot or anything…

Pablo

[Brittany_Gelbart]

Done! Thanks for the tip

[Reinout_Decock]

@Brittany_Gelbart

I have some control checkboxes (lets call them checkbox 1, checkbox 2, etc) and I want them to apply filters to a specific column (Columnb B) in a table when those boxes are checked.

If both checkboxes are true… you want both filters to be applied with OR or AND?
So column “Services & Topics” needs to contain

• both Education AND Career Interest Exploration
• or one of the two checked values?

[Brittany_Gelbart]

either/or. One of either of the checked values.

[Reinout_Decock]

Is there any reason you specificaly want checkboxes?
Because you can just create a control value with a multiple selectable pick list.

So you can select e.g. education, career interest exploration or both…

[joost_mineur]

If I understand correctly what you are trying to do, the filter formula should look like this: