Formula for identifying if record is linked to another

Topic Labels: Formulas
330 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi all,

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?


0 Replies 0