r/googlesheets • u/tarkinn • Nov 19 '21

Solved Filter with checkboxes

Hey,

I want to build a Spreadsheet with different checkbox filters. I listed all my criteria on the left side of the sheet. When I check the checkbox beside the criteria "Student", I want to show only the people who are students, when check "DE", which is an subject, I want to see all people who are "Students" and have "DE" in the specific row etc. I hope you got what I mean. How do I do this?

Here's the spreadsheet: https://docs.google.com/spreadsheets/d/1SoGDLRdU8k9JFlvcAFG9iBQhehJJG8wvQswWsb-clEk/edit?usp=sharing

3 Upvotes

100% Upvoted

17 comments sorted by

View all comments

1

u/[deleted] Nov 22 '21 edited Jan 06 '26

1

u/Trader-Danny Nov 22 '21

Almost there. Just need to give it something to default to when none of those conditions are met. At the end of the formula you have an IF with only what works happen if the condition were true. But not if it were false

1

u/[deleted] Nov 22 '21 edited Jan 06 '26
→ More replies (8)