Report - Don't want to show the main task

MatthewVC

Hello Smart Sheet crew!

So I have a few reports I use on my dashboard. One is "tasks due". I'd like it to only show sub tasks as the main tasks make it look a little confusing. Can I filter a report and only show sub tasks?

Neil Watson

I include a hidden helper column with a column formula =COUNT(ANCESTORS()).

You can then introduce a filter in your report to not include rows with a zero value.