I have this following board setup, my requirements are :
- Based on the “Launch Date” column, i need to automate populating “Copywriter Deadline” & “Designer Deadline” (All date columns)
- “Copywriter Deadline” & “Designer Deadline” can have different deadline, example Copywriter deadline is 3 days before launch date, while Designer can be 5 days before deadline
- I have actually found a automation that potentially (screenshot below) could satisfy the requirement. However very unfortunately, this automation does not work with Sub-item dates column :
Hence, I would like to find out if there are any other automation that could work with sub-item date columns. Preferably not paid external app as we are already paying enterprise pricing for Monday.com. Or appreciate it if there are other workaround solutions.