Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Assistance rolling up data to a master sheet
I’m trying to create a roll up for multiple resources across multiple sheets. I would like to have data roll up like how it looks in the Resource Allocation, but I’d like to view allocations in hours rather than percentages.
I've attached an example of a project schedule in SmartSheet that we use.
I thought that it might work to add a SUMIF formula to the bottom of each sheet and then link that data onto a master sheet. However, I cannot seem to separate data by weeks. I need to look at the upcoming hours per resource by project by week for the next four to six weeks, and grouped by weeks.
I've attached an example of what our resource hour tracking looks like from Excel. All of the hours per project per week would come from our individual project schedules.
Can someone point me in the right direction on how to create a report/sheet mimicking the resource allocation currently available but using duration?