Formulas are used to create filters.
To 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, 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 build a formula.
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).
You can create a formula that combines multiple conditions using multiple referenced columns as well as uses nested functions or constants.
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.
YEAR(#A) >= 2004 && YEAR(#A) <= 2010
SUM(#A;#C) == 100
#A < NOW()-7d
LEN(T(#A)) > 2