Past Due custom field/filter RRS feed

  • Question

  • Hi,

    I'm trying to create a custom filter to see all tasks that's Finish date is past "Today" and % complete is less than 100. After some online searching I learned I would need to create a column first with a formula to check if a task's finish date is less than Today's date and % Complete is less than 100. I came up with this formula:

    IIf(([Finish]<Date()) And ([% Complete]<100),"Overdue","")

    However,  I don't think this is valid as the column only returned "No" as a value. Can you please correct my formula or inform me how to create a filter to check if the [FINISH] column is less than Today and [% COMPLETE] is less than 100?


    Monday, November 10, 2014 9:00 PM


  • Hi Stepharr,

    I see what you are trying to do, but it's already in Project for you.  Insert the column STATUS and you will see these are autocalculated, based upon today's date (or the status date if it has been input).

    If you are not using Project 2013, you may need to refresh the view to "recalc" the status after updating the %complete.

    Ben Howard [MVP] | web | blog | book

    • Marked as answer by Stepharr Tuesday, November 11, 2014 3:38 PM
    Monday, November 10, 2014 9:16 PM