Is there a way to calculate start and due dates off of a fixed project end date?
Example: I have a project that I am working towards a go live of 5/1/2023
Each item should have a start date calculated off of the same go live date
Each item should have an due date calculated off of the go live date
*Dependencies between items can change - some items can be same day, 5 days between, 7 days between.
I was using the formula below, but it is requires a date completed to calculate and I am trying to get the start and due dates to show for all line items
FORMAT_DATE(ADD_DAYS({Date Completed},{Number of DaysA}))*
Hi @K_Couture - What you could do is have an “End Date” column, that gets populated for every entry, then utilize a number column for the number of days for each task based on the end date (you would need to enter as a negative).
Then use the following automation to calculate the due date:
Basically, the date would be your end date and the another date would be your due date column.
Hi Mark, sorry for jumping in here late.
I don’t see an option for that automation in the automation center. Am I doing something wrong when trying to build that automation?
Thanks
