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

Options
Ed19
Ed19
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

Comments

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

    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
    Options

    Ed19,

     

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

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

     

    Craig

This discussion has been closed.