AnsweredAssumed Answered

Calculate Totals from one SharePoint List to another

Question asked by amie.peterson@man.eu on Sep 10, 2018
Latest reply on Sep 20, 2018 by jpmhuls

Hi,

I have two lists. A Task list (custom list, also works as a time sheet) and a Project list.

Example Task list:

Example task list

Proj.no. (lookup from Project list), PlannedHourTask (numbers) and HoursWorkedTask (calculation from sublist). I also have a hidden column that is a copie of WorkedHoursTask (to be able to archive the tasks with hours worked).

 

Example Project list:

Example Project list

I want all hours worked (hours from task list) to be summarized in the project list under the right project no. Does anybody have any suggestion on solution?

Outcomes