Relative Due Dates

[Daniella_Delato]

Hey Airtable, I need your help!!!
I am a Project Manager and we plan for our projects based on the date we start construction.
All tasks that need to be completed are categorized by when we need to complete them, for example, the oven needs to be ordered 3 weeks before construction starts, so “Order Oven” would be under “week -3”.
That “week -3” would have a date assigned to it, relative to the “start date” so the formula would look something like ({startdate}, -3, ‘weeks’). That way, if the “start date” changes, then the rest of the schedule would automatically shift.
I’ve tried to play around but i can’t find a way to do this… please help!!!

[Jeremy_Oglesby]

You define a formula at the header of a “Field” (what you are calling a ‘column’). That formula then applies in each “cell” in that “Field”(column).

Example:

I define the formula that applies to the “Time in Mixer” column - any new record I create will apply this formula, which looks at the “Time of Loading” date field and the “Time of Sampling” date field from the same record (ie, horizontally), and uses them to calculate a duration in the “Time in Mixer” field.

Does that help?