I receive a due date and have to calculate backward to identify different milestones in our projects. What formula(s) do I need to use to make this work? I've attached a picture of what I'm trying to do.
Thanks in advance for the help!
I receive a due date and have to calculate backward to identify different milestones in our projects. What formula(s) do I need to use to make this work? I've attached a picture of what I'm trying to do.
Thanks in advance for the help!
You're gonna need to make a field for each of these milestones. Then subtract the days based on the final date, "Completion", which I assume is the due date.
An example would be to make a formula field, "Production Fee Due" with this formula:
DATEADD({Completion}, -1, 'days')
DATEADD({Completion}, -42, 'days')
DATEADD({Completion}, -{Production Fee Days}, 'days')
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.