I’ve got a board with 4 dates columns in it. When I set the first date, I want the other three dates (which are due date columns) to be automatically set at varied intervals (for Due Date 1, 11 days before Post Date, for Due Date 2, 9 days before Post Date, etc). Is this possible? Using automations, figured out how to adjust the dates if they’re already set, but I can’t figure out how to set the dates. Thanks for any input!
Some background if helpful: This board is essentially a social media calendar. Post Date is the date the post will go live. Due Date 1 is when the “Creation” stage should be completed, Due Date 2 is when the Approval stage should be done, and Due Date 3 represents the due date for the post being “Scheduled”