Hi there, I need help with an automation. I can schedule the trigger and an email, but the middle part of checking is delicate for me. See picture below.
I need the automation to:
- for the trigger being 14 days before the date field called 'handover date' is reached. This field exists in Task A
- Now lookup if any subtasks under Task B are still unresolved (Task B is under the same epic though)
- Depending on these 2 positive checks, it is to send an email (that part is easy)

Thanks.