Example formulas for default columns

[zcbeb10]

Is there any way of getting hold of the existing formulas in the default cells in MS Project?



I want to create a customised formula for a new column:

--
Start1 = "Finish1" Date of "Predecessor" + 1 day or "Project start date" if "Predecessor" is 0/valueless
--

Essentially this is the same as the default formula for column "Start" with reference to "Finish1" instead of "Finish".

So if i had access to the default column formulas im sure i could work out new formulas for my new columns.

Alternatively if these are not available, does anyone have a good list of basic formulas for MS Project or can anyone help with my specific query above.


I am trying to create 2 scenarios with different timelines for the same tasks.

Many thanks for your time.

[JulieS]

Sorry but you cannot refer to another task's data (predecessor) in custom fields. The only method to refer to other tasks is through code. (VBA for example).

Regarding two scenarios you can compare two versions of the same project. You can Save AS a different file name, change the data as needed and then compare.

Another alternative is to save the scenarios as interim plans and then use the Multiple Baselines Gantt to visually compare the results.

[zcbeb10]

Brilliant, the compare file function does exactly what i need.
Many thanks for your help.

[JulieS]

You're welcome. Glad to have helped and thanks for the feedback.