Rollup Calendar View
I am trying to find an easy way to "roll up" detail we track in a calendar view to show a summary view of the data. We are tracking deliverable assets for a marketing organization, which are organized by Target (Release XYZ) and Category (Buyers Journey Stage X). Other attributes include due date, owner, team, business unit, etc.
Creating the calendar to show the due date of the individual assets then supplying filters on that data to limit to specific releases, owners, etc. is pretty trivial. However, now I want to create a view that summarizes what shows up on a particular day like:
1. If there is ANY asset due on March 1, indicate that with a single item on that day. Clicking through on that item should take me to the various rows that were 'rolled up' for that day, across the various Targets and Categories.
2. If anything is due for Target XYZ on March 1, show a single item on that day, then clicking through on it should take me to the rows for all items for Target XYZ on that day (across Categories and Asset types).
I am a SmartSheet newbie, and have started to look at linked cells, and I'm assuming this is more of a data modeling exercise but not quite sure the best way to approach tackling this given the features SmartSheet supports.
Suggestions greatly appreciated!