Jump to content

Hoist Worksheet display on drawing

Recommended Posts

One possibility is to draw Polygons or Spaces for each area and give them names.


Then you can add a Criteria of Location is "Name of Polygon" along with whatever other criteria you are using. This will give you just the hoists for that area.


Or on re-reading your original post, it sounds like you want all of the hoists in a single worksheet. If you don't have too many areas you could do a bunch of nested IF statements, something like:


=If (Loc('Area_1_Name','Area 1',If(Loc('Area_2_Name),'Area 2', If(....)))))


however deep you need to go.


Or just add a custom record with a field that defines what the Area is for each hoist and report this in the worksheet.


Or about a dozen different options.


Give us a little more detail on what you are trying to do and why and we might be able to offer a better suggestion.

  • Like 1
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...