Can I hide a row once a status is marked as complete in a column using conditional formatting?



  • Amanda Carta

    You can via filters but it doesn't have the functionality like Excel. The filter would be to exclude anything in Status that says Closed.

    One thing I did for this same need is just have those rows moved to an identical sheet so it captured the data and had the formulas removed. Reason for this is that certain look up information changes at times and I wanted to keep the original data that particular row/s had when it was completed.

  • ALynch081

    Thank you! I am extremely new to Smartsheet. Can you please elaborate on how to move rows to an identical sheet? Thanks again