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".

Thank you.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!