none
Formula works in one project... not another RRS feed

  • Question

  • I am experimenting with a very simple formula.

    I am using a Start column and a Date1 column ... then using a Custom Number1 column to calculate the difference. Formula is [Start]-[Date1].

    This simple formula works fine in a new, fairly empty project file.  4/7/17 = Date; 10/2/17= Date1; calculated Number1=178

    The same formula gives no result (0) in an older, cluttered project file... using the same columns, dates, and definitions.

    Can you offer any possibilities as to why?

    Friday, October 13, 2017 5:56 PM

All replies

  • Drenaol --

    In the old existing project, you will probably need to press the F9 function key to get Microsoft Project to recalculate the project and the formula as well.  Hope this helps.


    Dale A. Howard [MVP]

    Friday, October 13, 2017 8:58 PM
    Moderator