#1
|
|||
|
|||
Rolling Resource Utilization and Tracking
Hi There,
Hoping to get some help. I have created a resource and capacity tracker with several formulas and conditional formatting built in to detect changes in capacity on a week to week basis. However, the problem I am trying to solve is, that when I update the utilization(that is in %), I only want it to update for the current week. For instance. If I change someone's utilization from 10% to 20% I would like it to update for that current week, but leave the previous weeks unchanged so I can have a rolling history. I have attached a couple of screen shots of what I mean. Hopefully someone can help. Thanks in advance. |
#2
|
||||
|
||||
Please post a sample sheet ( no pics please). Pictures are quite useless. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to have one task with people rolling on/rolling off at different times? | waileong | Project | 1 | 10-23-2021 07:20 PM |
automatically calculating employee utilization | makaveli80 | Excel | 7 | 03-08-2018 03:46 PM |
Resource Reports not showing Sub project Resource group hours | RichB | Project | 3 | 02-24-2017 08:55 AM |
Under utilization of resources | c991257 | Project | 1 | 04-17-2016 07:24 AM |
Adding resource name to Tracking Gantt bar | raminraiszadeh | Project | 5 | 09-28-2014 07:04 AM |