AnsweredAssumed Answered

Calculate Totals from one SharePoint List to another

Question asked by on Sep 10, 2018
Latest reply on Sep 26, 2018 by jpmhuls


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 (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?