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.

Using Resource Views



  • Not sure if the allocated column can have a formula, but to be honest, if its in the pipeline I am willing to wait. I would prefer it if I didn't have to hack each sheet to do something that should be native.



  • Travis
    Travis Employee

    Steve and Oliver, the following formula can be added to a Text/Number column and will display the number of hours the corresponding Allocation % is representing. This formula assumes you are working an 8 hour workday but you can adjust this if your workdays are longer or shorter:


    =[Allocation %]1 / 1 * 8

  • Gordon
    Gordon ✭✭✭✭✭
    edited 08/11/15

    Agreed re: allocating 1 resource per task.  I hope this feature can be added in the future.  For now, we are using indented, duplicate rows in our sheets for each resource need.

This discussion has been closed.