Is there a way to generate an alert/block on Smartsheet, in case a schedule causes overallocation?
![hilalt](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hello everyone,
On Smartsheet, I have a workspace containing a series of sheets (one for each active project) where various resources are planned.
Both on Smartsheet and Resource Management, each resource has 8 hours/day available (i.e., 1 day = 8 hours).
If I schedule a resource on two different sheets, assigning it to two different activities planned for the same day, the sum of the planned hours exceeds 8 hours/day, and in Resource Management, I correctly see the overallocation (red bar at 100%).
Is there a way to generate an alert and/or a block directly on Smartsheet, for example through automation, in case a schedule causes resource overallocation?
Answers
-
Hi @hilalt!
After researching our resources, there isn’t a direct feature to generate an alert or block when a schedule causes overallocation. However, you might be able to create a workaround using advanced reports in Resource Management.
What you could do is set up a report to show utilization by team member across all projects.
Once you've set up the report in Resource Management, be sure to click Advanced Report, give it a name, and select the destination so that it creates the assets in Smartsheet.
After generated, you can open the source sheet and create an automation. The automation can check the Utilization column, and if any value exceeds 100%, it can send an alert indicating overallocation. Just note that the alert will require the percentage to be in decimal form (range of 0 to 1).
Alternatively, you can use the "Met Utilization" column, which will show if a resource is over-utilized.
More details on advanced reports can be found here: Advanced Reports.
I know this isn’t exactly what you were looking for, but in case this workaround doesn’t fit your needs, I found an existing product idea you might be interested in: Resource Management: To notify managed users in Resource Management if they get overallocated. Be sure to add your vote to the idea!
I hope this helps!
Cheers,
Isaac.Need more information? 👀 |Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 |Global Discussions -
Hi Isaac, thank you so much for your detailed guide, I will try it!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives