I'm trying to modify a formula in my dashboard that currently uses multiple fields as filters inside an RSUM() aggregation. My goal is to apply OR logic across these fields rather than the default AN...
The FILTER function allows you to filter a range of data based on criteria you define. In the following example we used the formula Filter. Select monkey type Text Filters or Number Filters, and then select a comparison, like Between. Enter the filter criteria and select OK.. It is used for logical tests and can handle up to 255 conditions. The function's syntax is =OR(logical1, [logical2], …). It is often combined with other functions like IF and AND for complex decision-making processes.