Add a Formula Field in Fibery
Add a Formula field when you need a calculated value. A formula reads fields on the current record and connected records; it cannot update a workflow or create work.
Before you start: Use database configuration access. Create Number fields named Effort and Risk before following this example.
Worked example: A feature has Effort 3 and Risk 2. A simple review-weight field multiplies them to produce 6. This is an illustrative comparison aid, not a universal prioritization model.
Step-by-step guide
Define the calculation
Write down what the result means and what a larger value implies. Do not mix hours, story points and risk labels in one numeric input.
Add the calculated field
Use + New Field in the database and choose Formula. Name the result Review weight so its limited purpose remains clear.
Enter a minimal expression
Use Effort * Risk with the two Number fields. Check the editor accepts the expression before adding more logic.
Effort * RiskCompare known records
Use sample pairs 3 and 2, then 5 and 1. Expected results are 6 and 5; these are arithmetic checks, not observed customer results.
Check missing inputs
Inspect records with an empty Effort or Risk. Decide how missing data should be treated before relying on the sort order.
Common mistakes
Expecting a calculation to change another field
Use an automation for writes. A formula itself is read-only.
Referencing unrelated data
Connect the relevant databases first; a formula cannot fetch an arbitrary record with no relation path.
Sources and verification
Based on product documentation checked on 2026-11-04. This is a documentation-based guide, not a hands-on benchmark. Features and availability can change.