Project Team Widget

I want to make a dashboard widget for my project that shows a report containing all individuals that were assigned a task in said project. I know that the "assigned to" column can be pulled in a report, however it shows multiple instances of each person because each person does multiple tasks in each project. Is there anyway I can show the individuals in a project only once so that it can be put in a dashboard to quickly portray who is on the project team?

Find more posts tagged with

Reports

Project Management

Comments

Mick Jordan

I don't believe there is an easy way to achieve that. Someone might know of a formula based approach to pull out the unique values so you only get each name displayed once? How about using a graph widget to display a chart of individuals with tasks against them, that way the graph will do the job of only showing each resource name once?

Mick

Andrée Starå

Hi,

I can think of a few different ways to set it up. I need some more information to be able to test it out. Which roles and how many different people?

Do you have some screenshots on how it looks today?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

nishat722

Thanks for the input Andrée! I think a good way to show the individual team members once would be to show the resource view that is built into the smartsheet. Is there any way to put a widget of the resource view in a dashboard? If there is no way to do this, I can provide some screenshots of my sheet so that we can try and find a solution.

nishat722

Hi Mick, I tried to make a chart widget (I am not sure if it is the same as a graph but is the closest widget to it) however it only allows numerical data to be used.

Andrée Starå

Your welcome!

To my knowledge, there isn't a way to show the resource view in a Dashboard. Please upload some screenshots, and I'll see what we can do.

Best,

Andrée

nishat722

This is not the entire sheet as it would require multiple screenshots, however it does show that there are multiple tasks that have various individuals assigned to each task. My goal would be to show each individual once to quickly show project managers who would be working on a project.

Andrée Starå

If It's enough to see if the different people are involved in the project, I would create another sheet or put the information on the top of the project sheet. There you would see which people are part of the project and link that information to the dashboard. Just let me know if you need some more information.

Below you have the formula to count if there is assigned to for the different people. People 1, People 2 would have the exact name of the different people in the company and only the people that are present in the project will be counted. Would that work for you?

=COUNTIF([Assigned To]:[Assigned To]; People1)

Best,

Andrée

Mick Jordan

I agree with Andree, the project team will probably involve more than just the people allocated to task rows so my preference is to have either a separate sheet for listing the project team names or have their names at the top of the sheet.

Mick

Mick Jordan

Hi, if you set some formulas up to count the names of the individuals assigned to tasks then you can set a Chart Data range against that. If you get stuck drop me a line at mick.jordan@projectplanservices.co.uk and I'll share you an example.

Mick

Sign in to join the conversation!

Quick Links

Trending discussions

Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
License Question
I already have a Smartsheet license with my company, but I was recently invited to collaborate on a sheet owned by another group within the same organization. When I accepted, I was told I need to upgrade in order to edit or contribute. Can you please explain why this is required? It seems unreasonable to need multiple…