Report building

Jennifer Flanagan

Can I build a report that shows all items due in last 7 days and next 7 days, AND all items due if they are late (even if more than 7 days due?)

I can figure out how to condition my report on both those items,

Paul Newcome

Try setting up your report like so...

Jennifer Flanagan

Thanks! this is helpful. But is there is a way to show

a) All Tasks in the last 7 days and next 7 days, regardless if they are done or not

AND

b) all tasks that are in the past (beyond 7 days) and not yet done

Paul Newcome

Ah. Ok. I understand now. It may be easier to use a helper checkbox column on the sheet that contains a formula to automatically check the boxes on applicable rows and then build your report off of that checkbox column.