🧮 Formula Custom Fields: Calculated Values & Advanced Metrics

Managing complex projects and structured data often requires dynamic calculations. We are introducing Formula Custom Fields to allow you to compute values, calculate risk scores, and automate metrics directly within Collabase, eliminating the need to continuously export data to external spreadsheets just to run basic calculations.

Here is what we are scoping for Formula Fields:

➕ Mathematical Operations: Perform standard calculations (add, subtract, multiply, divide) using existing numeric custom fields or standard system properties (e.g., calculating "Remaining Budget" by subtracting logged hours from estimated hours).

🔀 Logical Functions (If/Else): Utilize conditional logic to dynamically output values or text based on the state of other fields. For example, automatically output "High Risk" if a financial impact field exceeds a specific threshold.

📅 Date Calculations: Compute the exact duration between dates. Easily calculate metrics like lead time or cycle time by finding the difference between a task's creation date and a custom "Deployment Date".

🔼 Hierarchical Rollups: Aggregate data from nested child tasks or linked Registry items. Automatically sum up financial costs, average out story points, or count the number of open sub-tasks directly on the parent epic.