Reference another sheet's multi pick
hello all... I have 2 sheets. The first is a Risk Log and the second is a summary of that risk log by project id.
In the first log I have a column "Driver" and it is a multi pick drop down with 11 possible values. For each risk, the user can pick 0-11 drivers to associate to that risk which is also associated to a project (Project ID). I would like to refernece that sheet from the Risk summary sheet and count for each project what drivers are selected in the risks associated to that Project
For example, Project 123 has 3 risks in the log. For risk 1, Driver - A, B C are selected. For risk 2, Driver B, H is selected and for Risk 3, Driver B is selected.
so what I would like to see on the summary for that project is Drivers = A, B, C, H. If Risk 1 gets closed, then it would show Drivers = B, H.
Any ideas>
Answers
-
Are you able to provide some screenshots with mock data for reference? It sounds like you are probably going to end up with a JOIN/COLLECT, but I can't be 100% sure based on just the description above.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!