I'm trying to create an automatically updated linked overview sheet to help my team to better visualize how their task assignements on various projects sometimes overlap. The resource views provided by the Smartsheet Resource view are just not that easy for the team members to parse and so they never use it... The "angry little red men" that are generated by the resource view provide some indication of overlapping task assignements, but they just aren't provideing the sort of comprehensive visual overview the we would like.
I've tried linking rows to other sheets, and I've tried adding department columns and running reports and nothering is giving me quite what I'm looking for.
Basically, I'm looking for something like the Content Department resource allocation pictured above (created in photoshop). And I'm interested in having the sheet linked to the project sheets in such a way that as the sheet updates, the dates and overlaps in the overview sheet are updated.
Ideas?
