found it: For the difference between Planned Date and Actual Completion Date, the formula would look like this.
WEEKDAYDIFF( Planned Completion Date,Actual Completion Date ) Eric Roybal Director, Project Management One & All
Hi All, Look for any suggestions. I would like to create a calculated custom field showing the variance (days late or days ahead) of project planned completion date vs actual completion date. I have tried created a custom field using this formula: SUB(Actual Completion Date,Planned Completion Date) ...
Has anyone come up with a report for view that takes fields from the portfolio homepage like on time and budget percentages? Looking to get a combined view rather than piecing this data together in other report managers. Eric Roybal Director, Project Management One & All
Hi Bill, I use Task>>Number of Children>>equals 0 text mode looks like this: numberOfChildren=0 numberOfChildren_Mod=eq I am sure there are other ways around this, but this omits the parent task and data from my task reports. Eric Roybal Director, Project Management One & All
Thanks Dustin. Rather than adding each user by name, can I call on them by role and get the same results? This would prevent me from having to update the report as a team fluctuates. Eric Roybal Director, Project Management One & All
Hi All, Looking for a way to create a hot sheet type report that doesn't take task owner into consideration. When I create the report below, if the task assignee IS NOT the task owner, the report does not present that person. I want to be able to see all assignees task list for a specific period of ...
Can anyone shed some light on how I can grant access to non-admins to be able to update a custom field in a report? In theory, I am looking for another way for users to provide an update in a grid/report view rather than posting in the updates section. See below for an idea of what I am thinking:
Is there a way I can format a date field (similar to excel) to format as a difference color when the actual completion date is later than the planned completion date? Eric Roybal Director, Project Management One & All