Text
      Back to home
      1. Help Center
      2. Operations
      3. Text

      FILTER Operation

      How to use the Filter operation in formulas

      Definition

      Example

      Syntax Guide

      Formula In Use

       

      Definition

      The FILTER operation returns a list of items that achieve certain conditions.

       

      Example

      FILTER(GT($$ITEM, 2), [1, 2, 3, 4])

      Result:
      [3, 4]

       

       

      Syntax Guide

      FILTER(condition, range)

      condition - An array formula evaluating to true or false

      range - The data to be filtered

       

      Formula In Use

      FILTER

       

      What's Next