Link the sum of a column in an Activity to a column in the Project List
I am trying to create a User Defined Field (UDF) within the Project List that calculates the number of Activities that would be due within that next two weeks and are not completed yet.
I have tried to use the Project Measures area, but that provides some sort of report when I just need a single value.
The reason this is important is because I want to be able to filter out projects that have no activities in the next two weeks from my two-week look-ahead report. Currently, if they are empty, I still get the header lines for the projects and with 80+ projects, weeding those out would save a lot of printer paper.
I have tried to use the Project Measures area, but that provides some sort of report when I just need a single value.
The reason this is important is because I want to be able to filter out projects that have no activities in the next two weeks from my two-week look-ahead report. Currently, if they are empty, I still get the header lines for the projects and with 80+ projects, weeding those out would save a lot of printer paper.
0