Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Resource Allocation


I'm having problems with the Resource Allocation column.  I created column, set it up for Resource Allocation in Project settings, but no matter what I enter in the cell for each task, the number defaults to 1


  • Jenny Lam

    The maximum resource allocation for each task can go between 0% and 100%. Look like the column you created for Allocation % was not formatted as %. Therefore, if you enter a value greater than 1, the cell will still show 1 (i.e. 100% which is the maximum allocation % for each task).


    Please try formatting the column as % (i.e. Select the column. Then on the left panel select "%"). 

This discussion has been closed.