standard ms project formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Project Training and help » Standard MS Project Formulas

Standard MS Project Formulas

resolvedResolved · High Priority · Version 2010

Stewart has attended:
No courses

Standard MS Project Formulas

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 which for a 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.

Many thanks for your time.

RE: Standard MS Project Formulas

Hi Stewart

Thank you for your question. Here is a Microsoft article describing the syntax of formulas in custom fields.

https://support.office.microsoft.com/en-gb/article/Project-functions-for-custom-fields-7e525143-380f-4083-8d5a-3ecc6ba44f22?CorrelationId=2811c550-4774-4de8-8cc2-4e7eb15269a7& ;ui=en-US&rs=en-GB&ad=GB

I hope you find this helpful - let us know if you have any further questions.

Kind regards,
Andrew

Wed 25 Feb 2015: Automatically marked as resolved.


 

MS Project tip:

Enter a Date

You can enter today's date (or tomorrow's date) in a date field, by simply typing in the word 'today'or 'tomorrow' and Project will insert the date for you.

View all MS Project hints and tips


Server loaded in 0.08 secs.