Resource management

@aldinag
@aldinag ✭✭✭
edited 12/09/19 in Smartsheet Basics

I am trying to create a resource management sheet to show who of my resources is busy or not and what his utilization % is. My resources travel to locations and i would like to be able to see in resource view the time that is being used for travel separately from the class time. 

Appreciate your help,

Aldina 

 

Comments

  • Hi Aldina, have you thought about using a seperate sheet just for travelling time.  The time spend travelling and class time would then be shown seperately in the Resource View.

    Mick

  • @aldinag
    @aldinag ✭✭✭

    Thanks @Mick Jordan

    I guess.. but that means having to build a new sheet from scratch... frown or is there a formula that I can do something like ..if the location is not .YXZ..then duration (whatever on the duration column)+6hours? (Not an excel expert tho..) 

    - still, the resource view uses start and end time not duration..i think. 

    Any thoughts?

    Thanks Mick.