I have 2 sheets. The first one is for case reviewer #1. It lists the case ID and the hours each day they worked on it. In total I have 3 reviewers and each have their own time sheet. Then, I have a summary sheet that lists the Case ID, each reviewer, and then the total time spent on each case. What I would like to do is on my summary sheet for each case and each reviewer, I would like to look up their sheet and sum the total hours they spent on each case so I do not have to manually enter the hours spent for each case for each reviewer. For example, screenshot 2 shows reviewer 1 spent 8 total hours on case 123, 16 on 456 and 7 on 789. I attached screen shots below. Thanks in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!