Calculating the Duration Between Actual Start Date of One Task and Actual Completion Date of Another

Question

I've created a report filtering for two parent tasks within one project: Plan Campaign and Execute Campaign. I want the report to show the number of weekdays that transpired between the actual start date of the Plan Completion parent task and the actual completion date of the Execute Campaign task. Any tips?

Thank you in advance!

Sven-iX · Accepted Answer

@dcshanno You can't.When you do a task report you get those 2 rows, each a task that has no connection to the other task. Therefore you can't create a calculation. Instead, if you put these 2 task inside a parent "Campaign" you automatically get the calculation in the duration property of that (grand)parent task "Campaign."

Doug_Den_Hoed__AtAppStore · Answer

Hi @dcshanno,

Building on the sage advice from @sven-ix, I invite you to consider this Going the Extra Milestone advanced technique to get what you need with minimal disruption to your existing Workplan structure(s).

If you like the latter, you can templatize it, going forward.

Going backwards...

If you want to take it even further, you could then also use our Sync Template solution to update existing Projects with those updated Template changes now, and thereafter, in a continuous improvement manner.

Regards,

Doug

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded