Skip to main content
NickVa7
Level 9
October 22, 2021
Beantwortet

Cross-Object Calculated Field (Sum Hours from all Tasks and Issues)

  • October 22, 2021
  • 3 Antworten
  • 764 Ansichten

Hi WF Community,

I'm looking to accomplish the following:

* Creation of a custom calculated field on the Project object called Billable Hours

* The logic for this field is as follows:

  • Use the sum value of all Actual Hours logged for all of the project's tasks and issues if this sum value is larger than the sum value of the project's Planned Hours from all of the tasks and issues

Is this possible? It's been a while since I played around with calculated fields, and can't recall how to grab the sum value from related objects (tasks and issues).

Thanks!

Nick

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von ChrisBudgen

Are you also timesheeting directly on the project? Because if not, all the hours on a project (field "Actual Hours") should already be the sum of all tasks/issues.

3 Antworten

RandyRoberts
Community Advisor
RandyRobertsCommunity Advisor
Community Advisor
October 25, 2021

I think you could aggregate hours on "work items" for this. From what I understand, a Work Item is both task and/or issue. You can then compare logged hours vs planned hours.

I know this is incredibly simplified but I think the approach is sound. Maybe someone who knows more about Work Items can chime in.

    ChrisBudgen
    ChrisBudgenAntwort
    Level 5
    November 3, 2021

    Are you also timesheeting directly on the project? Because if not, all the hours on a project (field "Actual Hours") should already be the sum of all tasks/issues.

    NickVa7Autor
    Level 9
    November 4, 2021

    Thanks, Randy and Chris. I forgot that the Actual Hours on the project object is a rollup of all hours from tasks and issues. That, combined with the Planned Hours (project object), should get me what I need in a calculated field with an IF statement. Cheers!

    Allgemeine NutzungsbedingungenAccessibility statement

    Loading footer...