VLOOKUP or INDEX
I'm trying to use smartsheet as a Resource Management tool, unfortunatelly we haven't get 10,000ft yet. so what I'm doing is to assign the resources that we need in each project:
- Project Manager and Allocation %
- Business Analyst and Allocation %
- Tech Leader and Allocation %
A person can be in different roles depending the project. so I can have
Person A as a project manager for Project A and
Person A as a Tech Leader for Project B... mmm 🤔 I know, it's not a good practice but that's how things are here.
now I want to have a report by person (no matter the role), to see the allocation % and the projects he/she is working on
how can I do that?
many thanks in advance for your help,
Help Article Resources
Check out the Formula Handbook template!