Skip to main content

​
Advanced filters

Every list supports combined filters with AND/OR and logical brackets.

​
Available operators

Field typeOperators
Textcontains, doesn’t contain, equals, different, empty, not empty
Number / Currency=, ≠, <, ≤, >, ≥, between, empty
Dateis, before, after, between, last N days, next N days
Selectis, is not, in list, empty
Referenceis, is not, any, empty
Checkboxyes, no
Formuladepends on output type

​
AND/OR groups

Filter editor with nested AND/OR groups
Example: (stage = Proposal OR stage = Negotiation) AND value > 20000 AND owner = me.

​
Filters on linked fields

Filter deals by a linked company attribute:
  • “Deals at Retail industry companies”: deal.company.industry = Retail
Navigate references with . in the field picker.

​
Computed columns (formulas)

Add columns without creating a permanent attribute on the object.
1

Add column

From list → + Column → Formula.
2

Write the expression

Use the editor with suggestions and live validation.
Formula editor with live value preview
3

Save

The column appears in the list, live-updated as records change.

​
Formula examples

// Weighted deal value
value * probability / 100

// Days since creation
DAYS_BETWEEN(created_at, TODAY())

// Priority based on value
IF(value > 50000, "High", IF(value > 10000, "Medium", "Low"))

// Contact full name
CONCAT(first_name, " ", last_name)

// Company YTD revenue
SUM(invoices WHERE invoice.date >= START_OF_YEAR() AND invoice.status = "Paid", amount)

​
Available functions

Numeric: SUM, AVG, MIN, MAX, ROUND, ABS, POWER Text: CONCAT, UPPER, LOWER, LEFT, RIGHT, LEN, REPLACE Date: TODAY, NOW, DAYS_BETWEEN, START_OF_MONTH, END_OF_YEAR, DATE, YEAR, MONTH Logic: IF, AND, OR, NOT, SWITCH Aggregations: SUM, COUNT, AVG on linked records with WHERE clause See Formula glossary for the full reference.

​
AI-assisted formula builder

Click Suggest with AI → describe in natural language (“I want a field that calculates days until deadline”). Arya generates the expression.

​
Frequently asked questions

Yes, every time input fields change. For expensive formulas Arya can enable caching (recompute every N minutes).
Yes, every formula column is filterable and sortable like a normal field.
No, a list formula column exists only in that list. For workspace-wide, create it as a permanent attribute in Object settings.