Resource Overallocation


Good morning,

I am managing a project with some very aggressive timelines using the Project Tracking and Rollup template set. I have added a column for Allocation %. My organization is in the process of purchasing enterprise licences, but currently we are just using a business licence, so I don't believe that we have access to resource management.

Is there a formula I can use to flag resource conflicts until we get our enterprise licences? Thank you


  • AravindGP
    AravindGP ✭✭✭✭✭

    Hi There,

    Not sure if your account is new, but you might still find "Resource Views" within Smartsheet, even in the business plan that you can leverage on. I have attached a screenshot. You can create a view to see all users in your Smartsheet account and their allocation across projects. The best way would be to go for Resource Management by Smartsheet, when you have the budget for it.



    Reach out for any help on licenses, configuration, or training

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!