Hello awesome airtable people … I am desperately in need of help after spending days going in circles.
I have a list of TASKS (podcast recording tasks in my case).
Some tasks have DEPENDENCIES - I can’t do task 2 until task 1 is complete
The list of TASKS is repeated for each podcast show.
In Airtable, I have a table for my podcast shows and a table for my tasks. I have almost everything working the way I would want if only I could I could figure out how to update the field: Dependency Done?
If I was to describe what I wanted, it would be a formula that says:
If there is a dependency task listed for this record and that task is done, mark this as TRUE, else FALSE.
I can get this work if there is only one episode by using a conditional lookup but as soon as I have multiple episodes, that doesn’t work.
I’ve stripped down my table to share in hopes someone has a great tip.
Help me Obi-Wan Kenobi, you’re my only hope!