Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula's for [Start Date] column when dependencies are enabled

edited 12/09/19 in Archived 2015 Posts



I am currently trying out Smartsheet in order to decide if we will be able to use this at our company or not.


I'm using the construction timeline with gant chart template.

I would like to add project management fee payment dates as milestones.


Payment #1 linked to start of the project -> OK, no problem

Payment #3 linked to end of the project -> OK, no problem


Payment #2:


I'd like to use the formula Start date of payment 1] + ([Start date of payment 3] - [Start date of payement 1]) / 2


It looks like it is not possible however to use a formula in the [Start Date] column if dependencies are enabled for the sheet. If dependencies are disabled I can use a formula, but then the milestone feature is not available.


Apart from calculating the date manually and update everytime the project start / end date changes, is there another way to do this?


  • BobbyLite

    @WCH you are correct in that you cannot add formulas to Date columns associated with dependencies. You could add an additional Date column to your sheet where you add this formula, then copy and paste the result over to your Start Date column.

This discussion has been closed.