Hello Smartsheet Team,
I have been using Smartsheet for over a year now and my organization benefits greatly from Smartsheet functions! However, resource allocation is something that prevents us from moving forward with Smartsheet fully.
There are 2 things that we struggle with:
1. Lack of option of flexibility in the %Allocation column (no formulas, no references allowed; time allocated in % - we operate by hours).
2. The way Smartsheet calculates % Allocation and distributes work across the days doesn't work for us at all. When we have a task that will take a couple of days and needs to be completed in February, we may not care about the exact days. Thus, if I make a start date 02/01 and end date 02/28, and assign a Person A to this task who will need only 5% of their time to complete the task (5% of their overall time in February), Smartsheet will allocate 5% on every day of February, instead of splitting this 5% by number of work days. Therefore, the time is not reflected accurately, as my intention is to have this person spend only 5% of their time within February, not 5% each day.
Are there any better ways to capture allocation %?
I hope that you will keep advancing your resource management function, as thus far, it has not been the strongest feature, and resource management is a crucial part of project management.
Thank you so much!