Jump to content
  • 0

Plant list worksheet not filling in scheduled size properly

Holly K


When I run a plant list worksheet the scheduled size is no longer showing properly in the cells, instead it says ='Plant Record'.'Scheduled Size' in the entire column. The other columns (plant name, quantity, ID, etc.) are working fine. I'm in VW 2021 on a Mac.

Link to comment

1 answer to this question

Recommended Posts

  • 0

Most likely there is a typo in either the field name or the formula that happened between VW2020 and VW2021.


Enter the worksheet in Edit mode (double click on the image). 

In the Worksheet View menu make sure there is check mark next to Database Headers. This should give you a row like 3 in addition to the 3.1, 3.2, ... subrows.

Click in the column header that is displaying improperly. Click on the disclosure triangle in that column header.

In the dialog box that opens, choose Record then Plant Record, then in the second row choose Scheduled Size.




Or just retype the formula to make sure there is not a typo.  ='Plant Record'.'Scheduled Size'


You can't have any extra spaces or it won't work.

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.

Answer this question...

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