NickSolyom Posted March 11 Share Posted March 11 Hello, may I have some help with making a simple inventory count worksheet? I have done Spotlight -> inventory and equipment lists filtered to lighting devices clicked the generate worksheet button Set column A to summarize so that each device is not it's own row How do I modify the COUNT formula to appropriately display the count rather than just (1)? Thank you Quote Link to comment
Vectorworks, Inc Employee Scott C. Parker Posted March 11 Vectorworks, Inc Employee Share Posted March 11 In the Count column, click the little box in the worksheet cell in row 3, then check the Sum Values box. Uncheck the Summarize Items in the same column. 1 Quote Link to comment
NickSolyom Posted March 11 Author Share Posted March 11 31 minutes ago, Scott C. Parker said: In the Count column, click the little box in the worksheet cell in row 3, then check the Sum Values box. Uncheck the Summarize Items in the same column. Thank you!! To confirm, I have to click "recalculate" in the object info palette to update the worksheet. Meaning, when I add a light or delete a light the worksheet is not "live" Quote Link to comment
Vectorworks, Inc Employee Scott C. Parker Posted March 11 Vectorworks, Inc Employee Share Posted March 11 36 minutes ago, NickSolyom said: worksheet is not "live" Correct, worksheets are not live. This is a performance issue. Imagine having a boatload of worksheets and all of them having to be updated when anything in the drawing changes. Quote Link to comment
NickSolyom Posted March 11 Author Share Posted March 11 Thank you @Scott C. Parker One more question, What do I put in my worksheet header to get the symbol to show up like in this Vectorworks university video Quote Link to comment
Vectorworks, Inc Employee Scott C. Parker Posted March 12 Vectorworks, Inc Employee Share Posted March 12 To add the image, you'll need to add an image column. The symbol images shown in the video isn't actually part of the create worksheet process. It's a good idea and I'll add it to our list of enhancement requests. Here's a video on how to add the image column. Thanks, Scott 2024-03-12_13-15-22.mp4 2 Quote Link to comment
NickSolyom Posted March 18 Author Share Posted March 18 @Scott C. Parker Thank you again! I have multiple files, all with a worksheet equipment list for counts, how would you recommend combining them all into 1 list. Exporting to excel? Quote Link to comment
Vectorworks, Inc Employee Scott C. Parker Posted March 20 Vectorworks, Inc Employee Share Posted March 20 On 3/18/2024 at 2:09 PM, NickSolyom said: how would you recommend combining them all into 1 list. Exporting to excel? Exporting into Excel is a good way to go if you like excel. 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.