curtain worksheet issue

[Peter Telleman]

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

[Tom W.]

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...

[Peter Telleman]

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

[Tom W.]

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

[Peter Telleman]

I'll definitely check out that coffee break, thanks a lot!

[Pat Stanford]

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.

[Peter Telleman]

Thanks Pat,

 

I'll look into this option as well. And yes, I'll probably start from scratch with this workbook.