Calculated fields allow you to automatically perform operations using numerical data from your items or from linked items. This helps you reduce manual work, maintain consistency, and get real-time insights as your data changes.
Why use calculated fields?
Save time by letting the system do the math for you.
Reduce errors in calculations across your workflows.
Get dynamic data that updates instantly when related values change.
For example:
Calculate the total cost of a construction project by multiplying quantity and unit price.
Track the average satisfaction score from linked feedback items.
Count how many active clients are linked to a specific account manager.
Two types of calculated fields
There are two ways to create calculated fields in Tuqqi, depending on where the data comes from.
Calculated fields within the same item
These formulas are based on numeric or calculated fields that belong to the same item.
You can use:
Fields of type Number
Fields of type Calculation
A fixed number (e.g., 10)
Available operators: +, -, *, /
You can also use parentheses to structure more complex formulas.
👉 The system will guide you step-by-step to build your formula.
Whenever you update any of the values used in the formula — from a table view, action center, or the full item view — the result will update automatically.
Calculated fields from linked items
These formulas are based on values from linked items. Here, you don’t write a custom formula — instead, you define a rule:
Choose an operation: Sum, Average, Count
Select the type of linked item you want to calculate from.
Choose the field within that linked item (must be numeric).
For example:
Count how many “Tasks” are linked to a project.
Calculate the total “Budget” from all linked proposals.
Get the average “Score” from linked surveys.
Whenever you edit the selected field in any linked item — or add/remove a linked item — the result in your calculated field will update instantly.
