How do I have multiple tasks inform the overall status of an item?

[mir4bell4 (Mirabella)]

I had hoped that the new custom automations feature would make something like this easier, in particular using the progress bar to trigger the automation since they are not completed in a particular order… but it’s still not possible: