I’m having trouble trying automatize 3 dates colums, here is my scenario:
I have a case in which I want to create and Item, and manually add a date. (Date1)
Based on this Date1, I need Date2 (which is empty and therefore it can’t be set to pushed) to be Date1 + 1 day (workday) and the I need Date3 (which is empty and therefore it can’t be set to pushed) to be Date2 + 4 workdays .
I habe been playing with custom automations but dates are pushed only if dates are already populated in their fileds. And I also tried another automation to move dates based on numbers colums but that does not take into account workdays vs regular days.
Thanks in advance