98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Standard MS Project Formulas
Standard MS Project Formulas
Resolved · 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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Enter a DateYou 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. |