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.