Jump to content
RMcK

How to input criteria in spreadsheet row of worksheet

Recommended Posts

I am trying to create a worksheet with multiple formulas in it. For this I need to be able to search different criteria in each column. The type is spaces. What is the order of the text I need to input into the cell to pick up with the criteria would do in a database row? I have looked through all of the following places and it is not very clear to a novice. 

http://developer.vectorworks.net/index.php/VS:Function_Reference_Appendix#attrCrit

http://developer.vectorworks.net/index.php/VS:Search_Criteria#Search_Criteria_Format

http://app-help.vectorworks.net/2016/eng/VW2016_Guide/Worksheets/Worksheet_Functions.htm

 

Thanks!

Share this post


Link to post

Most of the worksheet functions can take criteria as a parameter when they are in worksheet cells even though they don't need criteria when in a database header.

 

=AREA in a database header might become  =Area(((L='1-Floor') & (C='Red'))) when in a worksheet cell.

 

Tell us more about what you are doing. Especially why you don't want to use a database and we might be able to give you better suggestions.

Share this post


Link to post

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.


 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...