Need help with the formula
Hi All,
Am sharing the source file in excel format. We have overall 225 projects out of which I need only those projects names to be populated which meets the criteria.
1. We have 14 categories, under Primary Business Product Portfolio and 58 Execution projects under Project Phase Column in source file.
2. Only these 58 projects names should be populated under Project Phase Execution column from Source file in Report View. And if I select Clinical System Operations from dropdown it should populate only those project names which are associated with Clinical System Operations in the next column (Project Phase Execution) out of 58 Projects and similarly, if I select other Primary Business Product Portfolio from dropdown it should show the projects associated with that category.
Please anyone help me with the formula.
Thank you,
Hanuman Veda
Answers
-
Have you looked into creating a row report?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!