I am trying to create a task level view that displays the planned completion date by : the current duration divided by Project.Current # of Developers (Custom field at project level)..... Is this possible? I'm not having any luck today!
Topics help categorize Community content and increase your ability to discover relevant content.
OR to have my duration be custom? So # of Developers * # of Ideal Weeks (Both Custom Fields) = Duration...
If my Ideal Weeks = 70 & # of Developers = 4 .. My Duration should be 17.5?
Views
Replies
Total Likes
Hi Jordan,
So let me make sure I'm understanding - if the duration is 10 days and there are 2 developers on the project, the custom duration would be 5 days and you would want a custom planned completion date field that adds the custom duration to the planned start date?
I think this should work but partial days aren't quite exact...
displayname=test
linkedname=direct
textmode=true
valueexpression=ADDDAYS({plannedStartDate},(DIV(DIV({durationMinutes},480),{project}.{DE:Current # of Developers})))
valueformat=HTML
Hope that helps!
Views
Replies
Total Likes
THANK YOU!! Your understanding is accurate, yes!! This has certainly pushed me much further than I was but not sure it's there yet... If I'm looking at What if C @ 70 Weeks, I think I should be at 11/18/20 vs the 11/4/20 I'm seeing?
Views
Replies
Total Likes
Hi Jordan,
Are you using a 5 day schedule or a 7 day schedule for your projects? If you are using a 5 day, the calculated field will include weekends so you will need to add an extra two days for each week the duration spans. This should get you closer:
displayname=test
linkedname=direct
textmode=true
valueexpression=ADDDAYS({plannedStartDate},(SUM(DIV(DIV({durationMinutes},480),{project}.{DE:Current # of Developers}),ROUND(DIV(DIV({durationMinutes},480),3.5),0))))
valueformat=HTM
Views
Replies
Total Likes
Thank you so much! I'll keep going!!
Views
Replies
Total Likes