Is it possible to hide a row based on checkbox status?

Susan Peck

Hi,

We have some scheduling sheets with a set of tasks (deliverables) for each project. Each task has a checkbox to tell the team whether that deliverable is required for that project. If the checkbox is empty, cells in the row are filled with N/A and conditional formatting is applied. So the checkbox has both a formula and conditional formatting attached to it.

But, sometimes it would be nice to just hide the rows so you see only what is important. Is there a formula/function that would do that for us? We don't want to delete the rows because as the project progresses, we might need to make the task required.

Here is a screenshot of a couple of projects with different tasks not required:

Any thoughts?

It may be that a filter is our best solution. I don't want to rely on reports because people need to update the sheet directly.

Thanks for any help!

Susan

Andrée Starå

@Susan B Peck

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Susan,

There are two options.

• A filter as you mentioned
• A Conditional Formatting Rule that "hides" the information in the row

Which one do you prefer?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Susan Peck

@Andrée Starå

Thanks for the suggestions. I've tried the filter and it seems to work well while providing the flexibility to change the checkbox.

I'll also try the conditional formatting to hide the contents but probably the filter is the best solution.

You stay safe, too!

Have a great rest of your week.

susan

Andrée Starå

@Susan B Peck

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!