I have a simple task tracker with a single table containing a list of tasks. I have a self-linking field to allow for a single level of subtasks. I primarily use Interface lists to view tasks. However, I also assign tasks to be completed by varying people. So when I filter to a list of my assigned tasks, the nesting feature breaks. Airtable will only show me tasks if they are assigned to me. So if I am assigned to the parent task, I don't see the child tasks. And vice versa.
I thought it could be helpful to append an icon to the front of subtask names to cue me that something else is depending on me completing that task (haha) but can't figure out how to write a formula for that!
In the data views, the parent task has the child tasks linked in the subtasks field. So the child tasks have empty subtask fields. Therefore, I have nothing to search for.
Anyone have thoughts or worked through something similar? TIA!
