I have created a table for our small architectural firm based on the “project tracker” template I found in Airtable. Once a task is completed, I need to be able to hide the task in the table view so that it is clear at a glance where there is work to do for each project (and have the option to unhide for when I need to review task history). I have worked out how to filter tasks by their status in the Task tab but seem to be unable to do so in the main table.
When you are looking at the table, there’s no way to distinguish completed tasks from incompleted without opening up the row, and looking through all the tasks, which is causing me problems in meetings. Right now, the owners have me manually adding asterisks to the text of completed tasks AND I’m having to delete most completed tasks anyway, because they really pile up on the table view since I can’t hide them.
You can see an example of what I’m saying in the “project tracker” template. In that template, under the “Design Projects” tab, the first row for “coffee packaging” has one task: “research other coffee packaging”. If you check the “completed” check box for that task, it stays visible on the table. If you go to the “Tasks” tab, you can filter out completed tasks…but if you try to filter our completed tasks on the Design Projects table, it will remove any row/project that includes a completed task, and I need my table to include all active projects regardless of tasks.
I did find an older forum question and answer on this using a Lookup field, but I was unable to implement it properly. I added a “task status” column to my table that was a lookup on the “complete” checkmark in the task table. However when I filtered on that, I just got a column that has check marks in it when tasks are completed. (For instance, if a row has three tasks associated with it and two are done, the “task status” column just has two checks in it).
Any help is appreciated!