Resource management
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
-
Thanks @Mick Jordan
I guess.. but that means having to build a new sheet from scratch... 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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives