Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula for identifying if record is linked to another

Topic Labels: Formulas
555 0
cancel
Showing results for 
Search instead for 
Did you mean: 
pmhb2011
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?

Thanks!

0 Replies 0