Can we drive the Annotation family visibility states based on its 'host Sheet' in Revit? Not really.
Can we create a mapping table in Excel, Dynamo-push a single integer value into the Annotation instances based on the host Sheet, and drive the visibility by formula that way? Yep.
Here's the basic steps:
- I used dir and Notepad++ to make the list, one column in Excel for the lookup value (I used Sheet Number), and one for the parameter I want to get and use
- This relied on having the Family parameter list sorted Ascending in the Family Editor
- The Excel sheet looked a bit like this - notice how the driving parameter is an Integer?
- This is the work in progress in Dynamo - getting the Generic Annotation families, matching them up and getting the related Excel integer value
- This is the completed dyn, with the push back into the Element Parameter to drive the visibility - see how the string has to get converted ToNumber before pushing into the Integer parameter?
- And here is one instance in the project
- After running this once, all visibility states are set properly throughout the project