![](https://static.wixstatic.com/media/9d5ef8_a1cd7602ee2045d98f4b328a74c01177~mv2.png/v1/fill/w_396,h_127,al_c,q_85,enc_auto/9d5ef8_a1cd7602ee2045d98f4b328a74c01177~mv2.png)
![](https://static.wixstatic.com/media/9d5ef8_0efb728f98894f25beaf3724b198d354~mv2.png/v1/fill/w_362,h_190,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/9d5ef8_0efb728f98894f25beaf3724b198d354~mv2.png)
The Challenge
Herzing University had a problem, they were burning out their best employees and they did not know why. The Herzing leadership team lacked any sort of visibility into how their team was being allocated to projects across their organization. Moreover, they did not understand how their strategic objectives were connected to projects and how those projects were then mapped against people.
Herzing needed a digital solution that offered them simple visibility into their people's allocation to projects that also had the capability for intuitive time tracking and reporting.
The Solution
To begin, the Herzing team and myself started by creating a structure for how they organized and grouped projects and programs into strategic objectives. Then we created an Excel document to map out how people ideally should be allocated according to these strategic objectives. The Excel document helped us remain tool-agnostic while we built an understanding of the organization's capacity.
Figure 1
Excel Allocation Mapping per Project + per Strategic Initiative
![](https://static.wixstatic.com/media/9d5ef8_d9699ccb862c4e80bb59322e0f5a799a~mv2.png/v1/crop/x_0,y_0,w_1051,h_603/fill/w_896,h_514,al_c,q_90,usm_0.66_1.00_0.01,enc_auto/9d5ef8_d9699ccb862c4e80bb59322e0f5a799a~mv2.png)
Besides mapping people to projects, the Herzing University leadership team wanted to be able to map their projects and program groups towards their strategic priorities as an organization. The Herzing University CIO and I sat down to create a simple (Priority -> Program -> Project) hierarchy so we could eventually be assigning projects into groups with the use of Smartsheet's custom tags.
Figure 2
Strategic Priority, Program, & Project Hierarchy
![](https://static.wixstatic.com/media/9d5ef8_28d9fe5d44e14a8da36cebfac4189c7c~mv2.png/v1/crop/x_0,y_0,w_1218,h_712/fill/w_902,h_527,al_c,q_90,usm_0.66_1.00_0.01,enc_auto/9d5ef8_28d9fe5d44e14a8da36cebfac4189c7c~mv2.png)
After conducting a rigorous RFP, the Herzing team and I decided to use Smartsheet's Resource Management tool. Next, it was my task to help set up the solution with the custom project tagging and the team I had outlined beforehand.
The result is a simple, easy-to-navigate resource view across the organization. Figure 3 showcases the custom views tied to strategic priorities. Additionally, Figure 4 showcases how I was able to set up a custom view that allowed managers to see how their direct reports were allocated to projects, helping the Herzing leadership team ensure they were not burning out their employees.
Figure 3
Project Schedule with Custom Views
![](https://static.wixstatic.com/media/9d5ef8_4dde3ac4170b4541a5b317b81050712e~mv2.png/v1/fill/w_944,h_618,al_c,q_90,usm_0.66_1.00_0.01,enc_auto/9d5ef8_4dde3ac4170b4541a5b317b81050712e~mv2.png)
Figure 4
Manager Specific Schedule Views
![](https://static.wixstatic.com/media/9d5ef8_71af43b2ef184ec7b452fae9ca215031~mv2.png/v1/fill/w_794,h_736,al_c,q_90,usm_0.66_1.00_0.01,enc_auto/9d5ef8_71af43b2ef184ec7b452fae9ca215031~mv2.png)
Figure 5
GIF Walkthrough of the Final Solution
![](https://static.wixstatic.com/media/9d5ef8_6f88a82ef7cf4b74afd346d9c7a3861d~mv2.gif)