none
Formula Not Working RRS feed

  • Question

  • We have been using the following formula to check if the project has been baselined or not:

    IIf([Baseline Start] <> ProjDateValue("NA"), "Baselined", "Not Baselined")

    But it has stopped working all of a sudden.

    Please can you help.

    Friday, December 20, 2013 9:46 PM

All replies

  • Soigne,

    I do not see any mistake in your formula. When you say it is not working, what error do you see exactly?

    Also which version of Project are you using?

    Please give us some more details so that we can help.


    Prasanna Adavi,PMP,MCTS,MCITP,MCT http://thinkepm.blogspot.com

    Saturday, December 21, 2013 8:40 PM
    Moderator
  • We are using this formula to populate an Enterprise Custom Field. Up until now, every time we baselined a project file, this field would populate Baselined in the enterprise custom field. But now, even after baselining the project file, the enterprise custom field shows the value as Not Baselined.

    We are using MS Project Server 2010.

    Monday, December 23, 2013 3:55 AM
  • I recreated your formula and it worked in my test instance.  Did you publish the project?  Did you maybe only baseline specific task instead of the entire project?  If you open the project in pro can you see baseline values in the project summary (line 0) task?  If the project was published did you check the queue for any errors?  Did you try to create another custom field to test? 
    Monday, December 23, 2013 8:05 PM
  • One other thing to check is if the Calculation mode is set to auto.

    File >> Options >>Schedule, Calculate after each edit to on.

    You can force a manual calculate by hittingf F9 or navigating to Project Tab and clicking Calculate button.


    Prasanna Adavi,PMP,MCTS,MCITP,MCT http://thinkepm.blogspot.com

    Tuesday, December 24, 2013 6:59 PM
    Moderator