anytype-docs-features-formulas.md
For the complete documentation index, see llms.txt. This page is also available as Markdown.
Formulas let you summarize and aggregate Property values across the Objects in a Query or Collection. When you're looking at your data in Grid view, you can show counts, sums, averages, minimums, maximums, and other calculations at the bottom of any column.
The result is a row of summary values right under your data — useful for things like:
Total hours estimated across all tasks in a sprint
Average rating across all books in your reading list
Number of in-progress tasks per assignee
Sum of expenses per category
Count of Objects of each type
Formulas live at the bottom of each column in Grid view. Each column gets its own formula, so different columns can show different calculations.
To open the formula menu:
Open a Query or Collection in Grid view.
Click on the Property name in the header of a column.
Find # Calculate in the bottom of the menu.
Pick a option.
The result displays in the column footer and updates as your data changes.
The formulas available depend on the Property type of the column. Here's the full list:
Formula
What it calculates
None
No formula (default)
Count
Total number of Objects in the column
Count Unique Values
Number of distinct values
Count Empty
Number of Objects with no value in this column
Count Not Empty
Same as Count Values
Percent Empty
% of Objects with no value
Percent Not Empty
% of Objects with a value
Formula
What it calculates
Sum
Total of all values
Average
Mean value
Median
Middle value when sorted
Minimum
Smallest value
Maximum
Largest value
Range
Maximum − Minimum
Formulas are visual only — they're shown in the column footer but you can't reference them in another Object or use them in filters
No custom expressions — you choose from the list of available formulas; there's no way to write column1 + column2
Grid view only — other layouts (List, Gallery, Board) don't show formulas
Per-View — each View remembers its own formula choice, so a Grid View and a List View of the same Query don't share formulas
For more complex calculations, export the data to CSV and process it externally — or use the Anytype Agents Skill to run scripts against your data.
PreviousAdvanced FiltersNextCustom CSS
Last updated 3 hours ago
Was this helpful?