I’ve been going through the formula documentation and saw that Teable supports a good range of numeric, date, and array functions.
I wanted to check if there is any support for more advanced calculations that:
• depend on multiple records (e.g. aggregating a series of values with dates)
• require solving for a variable rather than direct calculation (e.g. finding a rate that balances a set of dated values)
For example:
Values: -5000, -2000, +8000
Dates: spread across different points in time
Is there currently any way to compute a rate that satisfies this relationship across all records (similar to an IRR/XIRR-type calculation)?
Or are formulas strictly evaluated per record without support for iterative/solver-type calculations?
If not natively supported, would you recommend handling this via external tools or automations?
From a functionality perspective, I’d love to suggest a few additions that could significantly expand capabilities:
• Native support for multi-record / dataset-level formulas
• Financial functions such as IRR / XIRR / NPV
• Solver-style or iterative calculation support (even in a limited form)
• More advanced array handling (e.g. mapping / reducing across arrays)
These types of features would make it possible to handle more complex analytical use cases directly within Teable, without relying on external tools.
Hi @Alex, thanks for the detailed feature request!
You’re right that Teable’s formulas are currently evaluated per-record. For multi-record aggregation, Teable already supports conditional lookup and conditional rollup — give those a try first. For use cases like IRR/XIRR/NPV that require iterative solving, the recommended approach is through Automations → Run Script — just describe what you need and have AI write the script for you.