Defines the filtering criteria for this sheet, if any.

An array which defines the filter configuration of individual columns.

An array of filter criteria for custom filters.

The operator type of the criterion.

The supported types vary based on the inferred column data type (inferred):

• Text - contains - The text contains the value. - doesnotcontain - The text does not contain the value. - startswith - The text starts with the value. - endswith - The text ends with the value.
• Date - eq - The date is the same as the value. - neq - The date is not the same as the value. - lt - The date is before the value. - gt - The date is after the value.
• Number - eq - Is equal to the value. - neq - Is not equal to the value. - gte - Is greater than or equal to the value. - gt - Is greater than the value. - lte - Is less than or equal to the value. - lt - Is less than the value.

The value for the criteria operator.

The filter that will apply to this column.

The supported filters are:

• value - Filters based on unique values.
• custom - Applies custom filtering criteria.
• top - Filters the top or bottom records.
• dynamic - Filters based on dynamic criteria.

The index of the column relative to the filter range.

The logical operator that will apply to filter criteria.

The supported values are:

• and
• or

The filter sub-type, if any.

The applicable types according to the main filter are:

• top
  • topNumber
  • topPercent
  • bottomNumber
  • bottomPercent
• dynamic
  • aboveAverage
  • belowAverage
  • tomorrow
  • today
  • yesterday
  • nextWeek
  • thisWeek
  • lastWeek
  • nextMonth
  • thisMonth
  • lastMonth
  • nextQuarter
  • thisQuarter
  • lastQuarter
  • nextYear
  • thisYear
  • lastYear
  • yearToDate

The filter value for filters that require a single value, for example, top.

The filter values for filters that support multiple values.

The active range for the filter, for example, B1:D8.