Resource allocation %
if people are working on multiple projects, is there a way to get their available % on the sheet in a column? Something like "Overall resource availability". For ex. If Person X is working 50% on project A on date 5/18/2020, I f I am working on project B and add Person X to this project on a line item with date 5/18/2020, it should tell me his availability for that day is 50%. I understand resource management has a view that can be used, but I would rather have this information auto populated on the project plan in the "Availability %" column to easily plan.
Help Article Resources
Check out the Formula Handbook template!