Get Notified When Project Allocations or Budget Usage Cross a Threshold

Created by Advaith R, Modified on Tue, 10 Nov at 11:52 AM by Advaith R

  • Plan Availability
  • Essential
  • Standard
  • Premium
  • Enterprise

As projects grow, allocations pile up across phases, placeholders, and resource requests. By the time someone notices that a project has far more hours allocated than planned, or that most of its budgeted hours are already used, the overrun is hard to recover from.

A global automation can watch these numbers for you. When a project's allocated hours or budget usage crosses a limit you set, Rocketlane notifies the project owner, a resource manager, or a Slack channel, so the team can act early.

Before you start

  • You need permission to manage global automations. See Setting Up Global Automations.
  • Time tracking must be turned on to monitor hours, such as Total Allocated Hours or Budgeted hours consumed %.
  • Financials must be turned on to monitor money, such as Budget consumed %.
  • Projects need budgeted hours or a budget for the percentage fields to have a value.

How it works

StepWhat happens
1. An allocation or time entry changesSomeone adds, edits, or deletes an allocation, or logs time on the project. This includes allocations created by auto-allocation and by approved resource requests.
2. Project numbers are recalculatedRocketlane updates the project's totals, such as Total Allocated Hours and Budgeted hours consumed %.
3. The automation checks the valueThe Financial field is updated trigger fires, and the condition checks whether the value has crossed your limit.
4. Someone is notifiedIf the value has crossed the limit, the automation sends the notification you set up.
NoteThe is greater than condition fires only when the value goes from at or below your limit to above it. People receive one alert when the limit is crossed, not one for every change after that. If the value drops below the limit and crosses it again, a new alert is sent.

Choose what to monitor

FieldWhat it measuresUse it to
Total Allocated HoursAll hours allocated on the project, for team members and placeholdersCatch projects where allocations grow beyond a set number of hours
Budgeted hours consumed %Hours logged as a percentage of the project's budgeted hoursWarn when a project is using up its budgeted hours
Budget consumed %Budget used as a percentage of the project's budgetWarn when a project is using up its budget
Project Budgeted HoursThe project's budgeted hoursSpot changes to the planned hours themselves
ImportantAutomations cannot check allocated hours as a percentage of budgeted hours, because the condition compares a field to a fixed number, not to another field. To monitor allocations, set a limit in hours with Total Allocated Hours. To monitor percentage usage, use Budgeted hours consumed % or Budget consumed %, which are based on logged time and spend.

Create the automation

  1. Go to Settings > Automations, select New automation, and then select Blank slate.
  2. Select Untitled and name the automation, for example "Allocation Threshold Alert".
  3. Under Trigger this rule on, select All projects.
  4. Under Project triggers, select Financial field is updated.
  5. In Select the field that’s updated, choose the field to monitor, for example Total Allocated Hours, and then select Done.

Financial field is updated trigger with the list of project financial fields

  1. In Action block 1, select Add conditions. Set the operator to is greater than and enter your limit in Value. For hours fields, enter the limit as a duration, for example 400h.
  2. Optional: select Add filter to limit the automation to certain projects, for example projects where Project Type is Fixed Fee. Then select Save.

Condition where updated Total Allocated Hours is greater than 400h 0m

  1. Select Add an actionand choose how to notify the team:
    • Notify someone sends an in-app notification. Under Who do you want to notify?, choose people or roles, for example Project owner. Under What message do you want to send?, enter the message, up to 300 characters.
    • Send an email sends an email.
    • Notify via slack posts to a Slack channel.

Notify someone action sending a message to the project owner

  1. Review the automation, and then select Save. Check that the automation is turned on in the automations list.

Completed automation: when Total Allocated Hours is greater than 400h, notify someone

TipDifferent kinds of projects need different limits. Create one automation per project group, each with a filter and its own limit, for example 400 hours for fixed-fee projects and 1,000 hours for retainers.

Examples

Alert when a project is over-allocated

A team plans fixed-fee implementations at around 400 hours. They want to know when allocations go beyond that.

  • Trigger: Financial field is updated > Total Allocated Hours
  • Condition: Total Allocated Hours is greater than 400h
  • Filter: Project Type is Fixed Fee
  • Action: Notify someone > Project owner and the resource manager

When a new allocation takes a fixed-fee project from 390 to 420 allocated hours, the project owner and resource manager are notified once.

Warn when budgeted hours are running out

A delivery lead wants an early warning before projects use up their budgeted hours.

  • Trigger: Financial field is updated > Budgeted hours consumed %
  • Condition: Budgeted hours consumed % is greater than 80
  • Action: Notify via slack > the delivery team's channel

When logged time on a project passes 80% of its budgeted hours, the team's Slack channel receives one alert.


FAQ

Can I get notified when a team member is over-allocated?

No. Automations cannot check a team member's allocation against their capacity. Use the overallocation indicators in Resource Management to find team members who are allocated beyond their capacity.

Can I alert when allocated hours exceed the budgeted hours?

Not directly. A condition compares a field to a fixed number, not to another field. Set a limit in hours with Total Allocated Hours, and use filters to apply different limits to different groups of projects.

Why didn't I get an alert even though the value is above the limit?

The alert is sent only when the value crosses the limit. If the value was already above the limit when the automation was turned on, no alert is sent until it drops below the limit and crosses it again.

Why don't I see Total Allocated Hours in the field list?

Time tracking is not turned on for your account. The hours fields appear only when time tracking is turned on, and the budget fields appear only when Financials is turned on.

Does the alert fire for allocations created from resource requests or auto-allocation?

Yes. Every allocation that is added, edited, or deleted updates the project's totals, whatever created it.

Can I use this on accounts with Multiple Project Budgets?

Yes, with a different set of fields. On accounts with Multiple Project Budgets, some project-level budget fields are not available in this trigger. Use the budget triggers instead, such as Budget field updated.


Summary

  • Use the Financial field is updated project trigger to watch project totals that change when allocations or time entries change.
  • Monitor allocations with Total Allocated Hours and a limit in hours, and monitor usage with Budgeted hours consumed % or Budget consumed %.
  • The is greater than condition sends one alert when the value crosses the limit.
  • Use filters to set different limits for different groups of projects.
  • Automations cannot alert on an individual team member's over-allocation or compare allocated hours to budgeted hours directly.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article

Contact our support team

Have more questions? Paid users can log in and email or chat with us.

Start your free trial