Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You can use formulas Formulas are used to create filters.

To filter data

...

open the filter feature, click Data from the menu and select Filter or click the Apply Filter

...

button on the toolbar.

...

 

To create use the formula builder, click the simple tab.

  • When entering a value in the Simple Tab, choose select a column to filter, select a expression to use, enter a value if needed, and select between Constant/Formula/Column from the drop-down list and enter build a formula.

Image Added


To create complex formulas, click the Advanced tab.

  • Click the Advanced tab in the Apply Filter dialog box and enter a formula such as TIMESTAMP(#A) < TIMESTAMP(NOW()-200000). 

Image Removed

To create complex formulas, click the Advanced tab.

Image Removed

Image Added

You can create a formula that combines multiple conditions using multiple referenced columns as well as uses nested functions or constants.

Learn more about Datameer functions that can be used in advanced filtering. 

Text-based expressions must return a Boolean value and they are required to reference columns in the current sheet. When the expression, applied to the current record, returns false, the record will be dropped. Otherwise it remains.

...