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.
Project Plan formulas into new columns
I've been asked if there is a way to have the same functionality/formulas found in project plan columns (Start/Finish/Duration/Predecessors) into new columns.
Basically, the project manager would like to set the initial project plan columns as the baseline, then add additional columns for projection and then more for actuals with all the built in calculations found in the original template.
I looked but these formulas are "hidden" and therefore unable to be reproduced. I was able to create the formula for calculating the duration between the Projected Start and Finish dates but when I change either of the dates the remainder of the plan projected dates stay the same and don't recalculate.
Is this even a possibility?