Hi,
I'm trying to put together a small automated timesheet system for a workplace and I have a basic set up where you can manually assign a job to a person on a master spreadsheet and it'll appear on their personal spreadsheet where they can enter their hours. I want to be able to move the time they've entered back to the master spreadsheet but the best I've been able to come up with is a whole bunch of IF formulas which check the person's name one by one. For example:
=IF($E3="All Staff",SUM('[Person 1.xlsx]Hour Tracker'!G4, '[Person 2.xlsx]Hour Tracker'!G4, '[Person 2.xlsx]Hour Tracker'!G4),IF($E3="Person 1",'[Person 1.xlsx]Hour Tracker'!G4,IF($E3="Person 2",'[Person 2.xlsx]Hour Tracker'!G4,IF($E3="Person 3",'[Person 3.xlsx]Hour Tracker'!G4,"")) etc.
Is there a more efficient way / better formula to do this?
Bookmarks