【Filter()】syntax error

[todo-yuya]

hello.
I want to get a filter that doesn't contain the corresponding string, but the filter doesn't look at the string. what should i do.

[Evelyn]

Hi @todo-yuya,

Welcome to the community and thank you for your question!

I'm having trouble understanding your question, however, this article might be helpful. If you still have questions, please respond with some additional context and possibly a screenshot example.

Thank you,
EveGold

[todo-yuya]

Thank you for reply.

I want to create a table that doesn't contain any specific characters in the filter, but it doesn't reference the characters.

[image]

Uploading: スクリーンショット 2022-07-01 11.56.40.png...

Does the filter only refer to cells?

[Dan]

Hi @todo-yuya!

One way to write a formula so it only returns the rows that contain no value (i.e., blank/empty) in a specific column is by parameterizing the conditions in the filter formula using a percent % and double quotes "".

Try this =FILTER(Product_data, "Product_data[JapaneseColumnName]=%", "")

Here is an article that walks through parameterizing conditions in detail if you're interested.

Hope this helps!

Kindly,

Dan