Guide
https://www.youtube.com/watch?v=gjeERWqE3iQ&t=5s
A Formula is a Field in Fibery and unlike other Fields it doesn't store anything. Just like in Excel or Notion, it takes values from other fields and calculates something new.
A Formula can't change a Field, move a state, or create anything, it is read-only. Which means you can't break anything with a Formula. It only looks and answers. Worst case – it shows an error.
Start with a Formula when you need to transform data – cheap and can't mess your setup. Then consider Automations.
In short, a Formula can only see an Entity it's related to.
For example, a task can grab its project field because task is related to project. But it can't reach into random Databases it has no link to.
This is because a Formula runs per entity – per record. Every task asks the Formula the same question: what's my answer? And to answer that, it needs to know where to pull data from. Without a Relation pointing at that data, it has no idea where to look.
Formulas run on relations
In Excel, any cell can grab any cell because they all have a fixed address in a grid (B3 is always B3). But Fibery is not a grid, it's Databases linked with Relations. Formulas depend on this.
How to write formulas
Formulas in Fibery include common operators and functions. For a full list, check Formulas list. Every formula in Fibery is built from three ingredients.
Paths
Paths are your doors. A dot sign. Open that Field or that Relation. Can open multiple doors: Epic.Product.Value
Arithmetic
Arithmetic are your usual operators.
+ - * / for math
= != < > for comparisons
and, or to combine conditions
() control order.
Functions
Functions are tools for anything arithmetic can't do alone. Rolling up a collection, matching text, pulling a piece off a date. Anything with a name and round brackets is a function.
Sum(), Find(), If()
AI for writing formulas
AI can help you a ton when writing Formulas. It can fix or edit Formulas you write yourself. Or you can ask AI to write a Formula for you, then edit if needed. Or just keep prompting until you get the result you need.
It is way more important to understand that Formulas rely on relations and set up your Workspace well than to know specific syntax. But again, check Formulas list if you're looking for specific functions.