Resource Management - Report of Over-Allocations?
Salwa
✭✭
Is there a way to get a report of anyone in the tool who has no assignments (0% allocation) or is over-allocated (>100% allocation)? I can view this information at a glance live in the Schedule tab with the Allocation Heatmap, but I'd like to export the information in a table (name, email, allocation percentage).
Answers
-
I think you would have to use an advanced report from RM that feeds info back to Smartsheet. It will create a sheet of the data you get, as well as reports, and you can build the report you want from that sheet. Take a report which is like the next 30 days for example so that it updates everyday and always show you future data.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.5K Get Help
- 448 Global Discussions
- 145 Industry Talk
- 481 Announcements
- 5.1K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 73 Community Job Board
- 492 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 304 Events
- 37 Webinars
- 7.3K Forum Archives