MS Project Formula Functions Reference Guide

Name: Crashing the CPM Schedule in MS Project: Back to Basics Ways of Working
Start: 2025-09-17T12:00:00-04:00
End: 2025-09-17T13:00:00-04:00
Location: Live Virtual Conference

Tagged: MS Project Formula Functions

This topic has 9 replies, 2 voices, and was last updated 2 years ago by jose65.

Viewing 7 reply threads

Author

Posts
- 12/04/2014 at 1:51 pm #263805
  
  Michael Wellhousen
  Participant
  
  Hello —
  
  I’m looking for recommendations regarding a User Guide (Manual) to the formula functions utilized in creating Custom Fields.
  
  Specifically something with detailed and understandable instruction regarding the formula syntax including examples.
  
  I’m not VBA proficient so I am looking for something that could be utilized by a non programmer.
  
  Thank you —
  
  Michael
- 12/07/2014 at 4:37 pm #267434
  
  Ismet Kocaman
  Member
  
  ☰ (https://office.microsoft.com/en-us/project-help/project-functions-for-custom-fields-HP010080956.aspx)
  ☰ (https://office.microsoft.com/en-us/access-help/guide-to-expression-syntax-HA010341730.aspx)
  ☰ (https://msdn.microsoft.com/en-us/library/office/ff836861%28v=office.14%29.aspx)
  ☰ (https://msdn.microsoft.com/en-us/library/office/ee767700%28v=office.14%29.aspx)
  ☰ (https://mpug.com/wp-content/uploads/2013/12/Customization-Formula-Guide-PDF-Version.pdf)
- 12/08/2014 at 10:08 am #268344
  
  Michael Wellhousen
  Guest
  
  Thank you Mr. Kocaman!
  - 12/08/2014 at 2:59 pm #268533
    
    Ismet Kocaman
    Member
    
    You’re welcome. If there is a particular formula subject that you need more information on, please do not hesitate to ask me directly at ikocaman.pm[at]gmail.com.
- 10/31/2018 at 8:34 am #413857
  
  michael manyuni
  Guest
  
  I want to generate % complete using custom fields with Final quantity (Budget) and todate quantity. I was able to get a % complete but not coming right with rolling up to summary headings to give me a weighted average completion.
  
  i.e %age complete = todate quantity/final quantity.
- 04/22/2021 at 1:05 am #482384
  
  abdalla
  Guest
  
  hello
  
  dear mr.kocaman i want a formula that will calculate how many days from start day till calendar day
- 04/12/2022 at 5:53 am #514306
  
  mollychopps22
  Participant
  
  i have question !
- 07/01/2022 at 6:37 am #532015
  
  Shisher
  Participant
  
  You have already written above, but those links are not valid, here is a new https://support.microsoft.com/en-us/office/project-functions-for-custom-fields-in-project-desktop-7e525143-380f-4083-8d5a-3ecc6ba44f22. In college, I once wrote an essay on this subject about education with MS Project. My work came out pretty good and you can visit here and read it. If I need to, I can add new links to replace the broken ones.
- 07/03/2023 at 4:17 pm #543720
  
  jose65
  Guest
  
  nice post!
Author

Posts