Jump to content

Different Worksheets not displaying the same data correctly


Recommended Posts

Hi All,

 

I am having an issue with one worksheet not showing the correct data.

Here is my example:

Worksheet 1 (displays all items correctly), Lists all stage deck items, Purpose, Size, and Height

Worksheet 2 (does not display the data correctly), Quantity of Stage Decks needed, Size, and Height

Worksheet one gives me 19 objects, 18 4x8 decks and 1 4x4 deck

Worksheet two gives me 19 objects, 19 4x8 decks

The Criteria on both is set to Type is Stage Deck and all the cells are set to the some record data.

My workaround is to manually add the one missing item

 

I've tryed coping the data headers from one to the other and no change.

 

Thank you!

Workshhet Data Issue.PNG

Link to comment

Thank you for looking at my file!

 

Yes both worksheets display 19 platforms. The problem is the individual platform counts.

 

Worksheet 1 (furniture) displays 4- 4x8 @2' and 15- 4x8 @ 3'

Worksheet 2 (staging) displays 1- 4x4 @ 2', 3- 4x8 @ 2', and 15- 4x8 @ 3'

 

If you look at the drawing worksheet 2 is correct. as far as i can see all the criteria are set the same. I tried copying the criteria from worksheet 2 to worksheet 1 and got the same wrong counting.

 

 

dcarr worksheet.vwx

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.

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