I’m trying to create a spreadsheet for work in which we allocate each other a certain amount of documents to process every few minutes. We are currently using a paper system where we write it down, however, I’m trying to create a spreadsheet to make this faster and more automated, and to not waste paper.
I’m a little stuck trying to figure out a function for the ‘Totals’ worksheet, which will sum up how much is assigned to a person based on a specific day.
In my spreadsheet I have manually input some of the totals into the ‘Totals’ worksheet, to give you an example of what I want to be achieved.
Hopefully, you guys might understand what I’m trying to achieve, but please reply if I’m being a little vague.
Also, is there a way of having the dates for the ‘Totals’ section automatically generate (without duplicates) from the dates in the ‘Allocation’ worksheet? So that when someone creates a new date in the ‘Allocation’ worksheet, it will automatically appear (hopefully in chronological order) in the dates section for the ‘Totals’ worksheet.
Allocation Spreadsheet - Dummy.zip
Bookmarks