List sheets where Legends are used


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.

  1. How do I put the two lists together? See attached jpeg “…with notes” for clarification.
  2. Is there a way to filter these lists so I only end up with the sheets that have the legend views on them?


I think that List.AddItemToFront with lacing on longest is what you need.

You can use View.Type from Clockwork to find and filter your Legend views. Then use AddItemToFront like @Alban_de_Chasteigner suggested to pair your sheet and view if necessary.