Conditional exclusion of rows

Ed19

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

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

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