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.