Can I hide rows using a condition?
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".
Help Article Resources
Check out the Formula Handbook template!