I have a base with two tables:
Projects: Lists current projects and the tasks assigned to them (linked)
Tasks: Lists all tasks with what project they are a part of (linked), their status and other notes and assignments on the tasks.
I would really like to have only the tasks that still need to be completed pull into the projects table, but when I use the link field type, it pulls all of the tasks of that project, when I use lookup, I can only pull in the various statuses of the tasks, I really just want to view the linked tasks that still need to be completed.
I figure something like the FIND function could help here, but I can’t find a description on how that function works, and when I tried a few things, I just got blank results.
Any suggestions would be appreciated!