Can I hide rows using a condition?

John Sisounthone

Hello,

Is there a way for me to hide rows if one of the cells says "completed" by using a conditioning format?

If that is not possible, is there a formula that I can implement that would get the job done?

I am managing a photography team and they have expressed the concern of seeing too much on their sheets that would distract them. Essentially, I would like the row to be hidden if the status says "completed".

Thank you.

Andrée Starå

Hi @John Sisounthone

Yes, you could either use a filter or a report to only show the rows that aren’t completed.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅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 @John Sisounthone

Yes, you could either use a filter or a report to only show the rows that aren’t completed.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅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!

John Sisounthone

@Andrée Starå

Thank you so much! I forgot about using the filter!

Have a great week!

Andrée Starå

@John Sisounthone

Easy to miss!

You're more than welcome!