FINDMANY & FINDFIRST

Where the TABLEFINDMANY and TABLEFINDFIRST functions are used to query ConvertCalculator Tables, we have created companion functions that can be used on regular Datasheets and on GoogleSheets:

• FINDMANY
• FINDFIRST

Both functions query data on the client, which makes them a bit less secure than our Table-functions, that query data on the server.

The FINDMANY and FINDFIRST functions are available under all plans.

FINDMANY

• matrix_reference: the matrix from which to retrieve a value. This can be a datasheet (e.g., DA) or a Google sheet imported with the GOOGLESHEET function.
• find_column_reference: the column in the datasheet from which to retrieve the value you are looking for. You can either reference the column by its letter reference (e.g., A, B, C) or its numerical reference (e.g., 0, 1, 2, 3)
• find_column_value: The value to look for in the referenced column. For instance, an email or ID.
• sort_column_reference: a column that sets the sorting for cases where multiple rows are returned.
• sort_column_order: the order to sort the column: ascending (1) or descending (-1).

FINDFIRST