wkwiat Posted November 27, 2018 Share Posted November 27, 2018 I have a large convention center project with many separate areas. I want to put a hoist worksheet on my viewport. But I do to want all the hoist to show up. How do i sort the criteria for the worksheet. Do I need to create a worksheet for each area? Thanks! Quote Link to comment
Pat Stanford Posted November 28, 2018 Share Posted November 28, 2018 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. 1 Quote Link to comment
wkwiat Posted December 4, 2018 Author Share Posted December 4, 2018 I was able to get a co-worker to finally explain worksheets and reports to me. I was able to create reports that were sorting based on function and origin. Thanks for the response though Pat! Quote Link to comment
Recommended Posts
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.