Project Online - Custom Field using Formula RRS feed

  • Question

  • Hello, 
    I am trying to create a new custom field using a formula to tell me if days since Project last published: 

    DateDiff("d",NOW(),[Last Published])

    However I get the error message saying:

    • This formula contains references to one or more fields that do not exist in the system. Correct the formula and try again.

    It appears the field "Last Published" is not available to be used in formula ? 

    Thursday, July 9, 2020 5:38 PM


  • Hello,

    The calculated fields don't recalculate when the view is loaded or when the project data is read, they will only update when the project is opened / updated then saved and published. This will result in the "days since last publish" calculated field always being 0 even if you last published a project 2 months ago. Fluent Pro backup allows you to filter Project Plans by modified date so that should work out of the box with Fluent Pro?


    Paul Mather | Twitter | | CPS | MVP | Downloads

    • Marked as answer by Tom_NguyenCA Friday, July 10, 2020 1:13 PM
    Thursday, July 9, 2020 10:43 PM

All replies