I was looking at the Airtable Automations. I can how to automate a record to update however is there a way to update on certain conditional logic?
I have two bases. One for Projects and one for Tasks.
Once all tasks associated with a project are marked as complete I want the Project Status to automatically mark as completed as well.
Any ideas around the best way to tackle this. When I setup the initial automation as soon as it found one task as complete the project was marked as complete even if other tasks were still with the status in progress.