Resource allocation total per group
Hi there,
I can see in resource view, you can see the individual resource utilisation, but can you see a aggregated total per group anywhere, without having to export to excel and adding formula's?
Cheers
Paul
Answers
-
One way to do this is create a separate "reference" sheet with resources and the group they belong to. Then use look-ups from your project sheets to count resources by groups, etc. and perhaps put it in the Sheet Summary section.
Hope that helps.
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Thanks Ramzi
I'll try your suggestion, to see if it works for this particular sheet.
I guess i was hoping there was just an option to show a summary view by group, the resource view is very limited in the options, seemingly just export to excel and do anything else there.
-
Hi @Paul Kemp
There is another Smartsheet Solution/Integration, 10,000ft that can provide you with much more Resource Management features.
Is that an option?
More info:
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives