I have a “tasks to do” table, which includes
- a linked field “prerequisite tasks” that links to the same table
- a date field “completed date”
- a formula field which counts 1 if the task is completed and 0 if it is not.
I want to count, for each task, the number of unfinished prerequisite tasks. However I can’t seem to create a count field as Airtable insists on using a link field to ANOTHER table.
Did I miss something?