VLOOKUP or INDEX
Dear all,
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,
Ana
Answers
-
Hi Ana,
Have you considered creating a report? If you did this, then you could include whatever columns you want the person to see. Then when you get to the Filters part, you can add a filter that looks like this:
Where the "1 value selected" is "Current User." Make sure you've got the connector (on the right side) set as "OR" so that it will pull projects that contain that person as either a PM or a tech leader.
I was able to mock it up, and it seemed to do the trick. Let me know if it works!
Best,
Heather
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!