I am looking to get help on structuring my base to track Deals, Tasks, and Subtasks without overcomplicating the fields and inputs. What I am struggling with is that some Tasks don’t have any Subtasks, so I created a separate “status” field for just Tasks. Right now I have Tasks and Subtasks in separate tables with Subtasks linked to their appropriate Tasks. This is fine, but it’s a little awkward and annoying that I have two status fields now at two different levels. Especially in interfaces.
Why do I have a status field for Tasks and Subtasks? I want to automate when all the Subtasks are complete, then that parent Task is filtered out and no longer shows on my interface. If a Task doesn’t have Subtasks, then I need to have a separate status field for Tasks so when they are complete, they will also filter out when complete.
In short, I imagine there is a solution or more efficient alternative given this is a very basic Project-Tasks-Subtasks structure that thousands of people probably have set up already. I’m not married to my current set up in any way.
