[FAQ000125]Is it possible to set the filter refinement automatically in an action?

Q

Is it possible to set the filter refinement automatically in an action?

A

In CELF, the "Set cell as filter range" action can be used to add a filter itself,

but it cannot be used to narrow down the data.

To automatically refine the data, the following methods are possible.

・Expand the list on the sheet with the "Get multiple records from table" action to narrow down the list

・Use the "Hide Rows" action to hide non-target data

and create a filtered state on the sheet

Related keywords

Filter