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.

Conditional exclusion of rows

edited 12/09/19 in Archived 2016 Posts

I want to have a sheet where based on a condition like a checked box certain rows are or are not available.  For example if CAPEX is not checked then the Capex task rows are not available to see.  Is this possible


  • JohnHinkle
    JohnHinkle ✭✭✭✭✭✭
    edited 04/29/16

    You can use filters to show/hide rows based on conditions. If you want all rows with CAPEX checked hidden, set a filter for that column to hide those rows. If you simply want to check a box, add a formula to each row that will show a value if that checkbox is checked then filter based on that value/column. 

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 05/01/16



    You can also use Reports to edit and display your data.

    If your users aren't adding rows, this will likely help your solution.



This discussion has been closed.