Full disclosure - I have been using the PMO template and modifying it for our needs. It was a great starter, but needed some additional tweaks to suit our purposes.
I added a sheet that dynamically collects all the unique names to make it easier to dynamically display them on my dashboard: (a big thank you to @Cleversheet for getting me started in the right direction!)
The original widget was a Metric Widget, that wasn't really dynamic, but very nice looking:
I am trying to have the ability to dynamically populate the widget, but when I try to have it stacked, I end up with:
and side-by-side is even worse:
I understand I can delete the field name, and get something like this:
but I am losing the dynamic nature of the widget. I would like to simply list the Name and role as individuals get assigned to the project. Something like:
-----
PROJECT SPONSOR NAME
Project Sponsor
PROJECT MANAGER NAME
Project Manager
NAME A
NAME B
NAME C
Team Member
-----
Is something like this possible, or will this widget need to be populated and updated constantly? I am building out my project templates, trying to automate the project initiation as much as possible, and looking to have as much on the dashboard populate from data that I am already filling in elsewhere.
On a related note: since we can't point the data to columns, I already need to select the cells needed - is there a way to have it point to the columns, and use the filtering I have on the table? As I add tasks, the number of unique names will potentially change, requiring me to "touch" the widget source each time. I had thought about pointing the whole thing to the project metadata, and having fields with the project roles, but that seemed like it would be over-kill, and would potentially lead to a bunch of empty space in the widget for roles that weren't needed, or where one person might have several project roles.
