none
Project Custom Fields Formulae - Online Resources RRS feed

  • Question

  • Hi all, what is the best online resource detailing PSP formulae? I am very familiar with excel, but the syntax used in project is quite different.
    Tuesday, March 1, 2016 3:56 PM

Answers

  • Hi all, what is the best online resource detailing PSP formulae? I am very familiar with excel, but the syntax used in project is quite different.

    Pls check this ebook and articles on formulas here at  http://www.ismetkocaman.com/Formulas/eBook.html

    Please feel free to drop me a line for questions on formulas or feedback on the book. 

    • Proposed as answer by Tom BoyleBPC Friday, March 4, 2016 2:06 PM
    • Marked as answer by rapscalli Friday, March 4, 2016 2:57 PM
    • Edited by Ismet Kocaman Tuesday, October 3, 2017 10:27 PM url update
    Friday, March 4, 2016 1:40 PM

All replies

  • VBA for Project really has nothing to do with Excel, other than it's VB.

    It's not online, but the book "VBA Programming for Microsoft Project" by Rod Gill ISBN 978-1-934240-21-2 is the definitive resource.  Rod is active here.

    In Project's Help, (Menu: Help from the VBA part of Project) there is a link to a Microsoft Project internet site.  I think (but not sure) it's different for each version of Project.  But for Project 2013 it points to https://msdn.microsoft.com/en-us/library/fp161358(v=office.15).aspx


    --rms www.rmschneider.com


    • Edited by Rob Schneider Tuesday, March 1, 2016 5:01 PM typo and URL
    Tuesday, March 1, 2016 4:56 PM
  • VBA for Project really has nothing to do with Excel, other than it's VB.

    It's not online, but the book "VBA Programming for Microsoft Project" by Rod Gill ISBN 978-1-934240-21-2 is the definitive resource.  Rod is active here.

    In Project's Help, (Menu: Help from the VBA part of Project) there is a link to a Microsoft Project internet site.  I think (but not sure) it's different for each version of Project.  But for Project 2013 it points to https://msdn.microsoft.com/en-us/library/fp161358(v=office.15).aspx


    --rms www.rmschneider.com


    Thanks Rob, hadn't realised the formulas were VB syntax. I shall see if my manager will sign off the book!
    Tuesday, March 1, 2016 6:54 PM
  • Not sure if this can help...

    try to have a look at this link: https://support.office.com/en-us/article/Project-functions-for-custom-fields-7e525143-380f-4083-8d5a-3ecc6ba44f22

    it list all the functions....

    Cheers 

    Ivan

    Wednesday, March 2, 2016 12:51 AM
  • Thanks all for the replies (and quitly ignoring my miss-spelling).

    Are there any blogs or resources that discuss formulae construction for a beginner?

    Thursday, March 3, 2016 10:48 AM
  • Rapscalli,

    The best resource is the book I provided you a reference for.  Yes, you need to buy it; but then it's worth it. Few will blog for "free" on such an esoteric (but useful!) topic.  People who know these things tend to spend their time doing these things for pay and not for free. 


    --rms www.rmschneider.com

    Thursday, March 3, 2016 10:50 AM
  • I can but ask!

    Thursday, March 3, 2016 10:53 AM
  • Actually there are several great blog posts with code and good tips etc (Paul Mather's is excellent) where you can see he has blogged quality information - I'm specifically thinking of his excel oData reports.  The issue with formulas is that they are so specific

    I would also point you to the MPUG - a quick search for formulas their site came up trumps - http://www.mpug.com/articles/an-update-status-indicator-for-microsoft-project/


    Ben Howard [MVP] | web | blog | book | P2O

    Thursday, March 3, 2016 2:18 PM
    Moderator
  • Rapscalli,

    Rod's book does have a good introductory chapter on custom fields and formulas, but the other 340 of its 365 pages are aimed at vba and vsto programming.  I consider vba to be quite distinct from formulas in custom fields, which is what you asked about, and buying the book may be overkill for a beginner.

    This is a good go-to source to start with:

    https://msdn.microsoft.com/en-us/library/office/ee767700(v=office.14).aspx

    and there is virtually no Project formula function (or vba function) that you can't find documentation for on MSDN. Be advised that there are some vba-derived functions that do work in custom field formulas, but many do not.  I've not found a listing of them all.  You really never know until you try.

    Good luck. tom

    Thursday, March 3, 2016 5:38 PM
  • Hi all, what is the best online resource detailing PSP formulae? I am very familiar with excel, but the syntax used in project is quite different.

    Pls check this ebook and articles on formulas here at  http://www.ismetkocaman.com/Formulas/eBook.html

    Please feel free to drop me a line for questions on formulas or feedback on the book. 

    • Proposed as answer by Tom BoyleBPC Friday, March 4, 2016 2:06 PM
    • Marked as answer by rapscalli Friday, March 4, 2016 2:57 PM
    • Edited by Ismet Kocaman Tuesday, October 3, 2017 10:27 PM url update
    Friday, March 4, 2016 1:40 PM