filter() documentation shows the example:
FILTER([DateStart_wDay], [End] = โ07:15:33โ)
Using this syntax generates the error:
Function โFILTERโ should have exactly two parameters, a table name and a filter condition
Replacing [ table ] with โtableโ works. Is there a case where [table] is appropriate?
Where do you see it like FILTER([DateStart_wDay]โฆ)?
Hi Aleksi,
It appears in the code editor, LISTS functions page, as the example for FILTER().
okay, thanks.
Nope. The first argument to FILTER() must be a quoted or unquoted literal table or slice name, and may not be an expression.
Thanks again Steve.
Tagged as Bug-issues-errors
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |