I’m using the Team Projects and Tasks template and have added a control and filter to show only tasks due today, in the next 3 days, all unscheduled tasks, etc. That much works. But because the Project column is added manually, even those rows with no tasks that match my criteria show in the table with the Task column blank and the Task count value of 0.
This is what my filter looks like. (And if you have suggestions for cleaning it up, please share).
if(View.Contains(“All Tasks”),thisRow.Task.IsNotBlank(),If(View.Contains(“All Unscheduled Tasks”), thisRow.[Due Date].IsBlank(), thisRow.Status.Contains(“Blocked”,“In Progress”,“Not Started”) AND if(View.isblank(),true(),thisRow.[Due Date]< Today() + Switch(View,“Today’s Tasks”,1,“Next 3 Days”,3,“Next 7 Days”,7,9999))))
I tried adding a check for Task.Count()>0. But that didn’t work. The blank rows continue to show.