Peter Telleman Posted March 26 Share Posted March 26 curtain worksheet issue.vwxHi Everyone, I've made a worksheet to count the drapes of my different styles of curtains. Now we have some symbols that fall in the same soft goods category, how do I alter my worksheet to include these symbols, preferably in the same rows? I've added a file with curtain styles, the worksheet, and one symbol I'd like to include. Thanks in advance, Peter curtain worksheet issue.zip Quote Link to comment
Tom W. Posted March 27 Share Posted March 27 I'd probably just add another database under the first one. Like this: By the way I have no idea why your B column is displaying blank in the worksheet! The data is there, it just isn't showing... 1 Quote Link to comment
Peter Telleman Posted March 27 Author Share Posted March 27 (edited) Hi Tom, Thanks for thinking with me here. The proposed solution looks good, how do I add another database in the same worksheet? (I'm really not very good with worksheets) I changed the alignment of the text to center, and then it shows it. I'm with you in not knowing why left indent wasn't showing the values. Thanks, Peter Edited March 27 by Peter Telleman Quote Link to comment
Tom W. Posted March 27 Share Posted March 27 You need to expand the worksheet to create an extra row then right-click on the new spreadsheet row (6) + select 'Create Report...': Maybe have a look at recent Coffee Break on Worksheets by @michaelk: https://university.vectorworks.net/mod/overview/view.php?id=6579 2 Quote Link to comment
Peter Telleman Posted March 27 Author Share Posted March 27 I'll definitely check out that coffee break, thanks a lot! Quote Link to comment
Pat Stanford Posted March 27 Share Posted March 27 Or if you want them all in a single database you can get fancy. But then you will also have to use fancy IF formulas also. And you will lose the 2-way ability to change the object from the worksheet, but I think the VALUE command already does that. Here is the revised formula for Columns A and B. Col A =IF(Style.'Name'<>'', Style.'Name', SYMBOLNAME) Col B =IF(OBJECTTYPE=15, 1, VALUE(OBJECTDATA('INVENTORY PART PARAM', 'Curtain', 1, 5))) Col A shows the SoftGoods name there is one, if not, it shows the Symbol Name. Col B checks if the object is a symbol and if so it sets the count to 1 otherwise it uses the original formula. And I recommend that you dump this test file, or at least the worksheet you have been using. There is something really funky about the cell formatting that is causing problems. 1 Quote Link to comment
Peter Telleman Posted March 28 Author Share Posted March 28 Thanks Pat, I'll look into this option as well. And yes, I'll probably start from scratch with this workbook. 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.