Resource allocation with multiple assigned to

edited 12/09/19 in Formulas and Functions

Good day all,

I'm working with resource allocation across multiple projects.  Resource allocation is turned on for the account and then turn on and off for each sheet I want in the overall program.

My understanding is that %allocation is assumed to be at 100% when there's no %allocation column specifying otherwise. 

In our projects we use multiple resources assigned to a task.... a lead, a manager, a scientist and a technician, each with their own %allocation for a specific task.  

I am able to create the columns and auto-calculate the %allocation based on duration and the work within that duration.

Is it possible to have multiple %allocation columns? and assign one for each resource? 

Thanks in advance,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!