Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Make a row dissapear from a sheet

Andy Hitchman
edited 12/09/19 in Archived 2015 Posts

Very basic question, I have a list of jobs in a Sheets. is it possible to make the row dissapear if I mark that row as done using a drop down list. I know longer need the row info in my sheets and I want to keep my sheets down to a managable size.


  • Nemesis
    edited 07/30/15

    Once you have either checked the 'done' box or marked completion as 100%, you can filter the rows. Hover over the column title (Done/ % Complete) and you will see a drop down button. Click on this and you will see 'Filter Column...' as one of the options.

    Click on this and you can then customise the criteria for filtering - pretty simple. This also allows you to choose whether you want the rows/ cells that meet the criteria to be the visible ones or to be hidden. 

This discussion has been closed.