I'm using Airtable to plan and track renovation and landscaping tasks. I have a table that has one field (text) for tasks and a 'prerequisites' field that is linked to the tasks field. This shows me other tasks that need to be done first. I am trying to create a formula that will show me whether the task at hand is a prerequisite task for any others.
I tried IF(FIND(Task,Prerequisite),"Yes","No") but that (kind of obviously) always return "No" because a task is never a prerequisite of itself.
How can I get it to identify if the a task is a prerequisite for any other task?
Alternatively, is it possible yet to automatically produce a field for the link in the opposite direction when records are linked within the same table?