Filtering a Report

Caleb W

I have all of prejob tasks pulled into one report and I am wondering if there is a way to set a filter to hide all completed, only show what is late and due in the next 14 days.

SoS | Dan Palenchar

Yes - Select the "Filter Criteria" button at the top of the report and add these in.

In this example I have a "Status" drop down column with Complete as an option, a "Due Date" column, and a flag column that if flagged means an item is late. Based on your Sheet structure (columns) you will have to adjust the criteria accordingly.

Dan Palenchar | School of Sheets Solutions Consulting (Smartsheet Aligned Gold Partner)

Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus

Smartsheet Tutorial Videos: schoolofsheets.com/youtube

*If this response helped you please help me and the community by accepting it and reacting as you deem appropriate (insightful, vote up, awesome)*

Caleb W

Thank you! It seams that the due and late block one another out.