- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 25, 2023 06:33 PM - edited ‎Sep 25, 2023 07:36 PM
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!
