Setting up resourcing sheet


I'm using smartsheet to manage assay requests that my team receives. On a separate sheet, I have calculated the amount of time it takes to complete each type of assay, which varies by sample number. I would like to set up another sheet to display the amount of time each assay operator is putting towards running each type of assay.

For example, if Joe receives a request to run Assay 1 with 55 samples, I want the amount of time it takes to run 55 samples for Assay 1 displayed in the resourcing sheet next to Joe's name. Ideally, I would like to tally the total hours that each operator puts towards running all assays per quarter. Joe will run different amounts of assays with different amounts of samples each quarter, and I would like a breakdown of the time Joe puts towards running assays each quarter.

Does anyone have any thoughts on how I could accomplish this?

This is a screenshot of the assay time calculations per sample (the thaw/prep time is not dependent on sample number)

Best Answer