% Allocation Formula for Assigned To column
Can you please help me come up with an IF formula to use in the % Allocation column for my sheet?
This is what I am trying to formulate:
If Bob (from the ‘Assigned To’ column) reaches greater than 100% allocation (from the sum of multiple rows), make the ‘Assigned To’ cell Fill in Red for wherever Bob’s name is. Example below shows over allocation at 101%. If you would recommend a different flag other then highlighting All of bobs name in red, please let me know. No budget for 10000 ft/resource management yet.
Also, is there another formula you can propose if there are multiple people in a single cell? How would % allocation work then?
Thank you for your help!
Help Article Resources
Check out the Formula Handbook template!