I’m trying to create a list that shows which sheets have which legend views. So far all I’ve managed to do is create 2 separate lists, one showing the sheet numbers and another showing the views associated to each corresponding sheet. I’ve figured out that the views that only list as “View” with the green ID number are the legends.
- How do I put the two lists together? See attached jpeg “…with notes” for clarification.
- Is there a way to filter these lists so I only end up with the sheets that have the legend views on them?