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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

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.

×