Feature Requests

We value your feedback! You can vote for existing posts, add comments or add your own.
Materialized” Formula/Lookup Fields for Use in Other Formulas
Hi SmartSuite team, I’d love a way to create a duplicate of an existing Formula or Lookup field as a “plain” field (Text or Number) that I can then safely use in subsequent formulas. The problem, Right now, when we try to build formulas on top of other formulas or lookups, we run into issues such as: Formula dependencies getting messy or unstable, Unexpected errors or recalculation problems when formulas reference other formulas, Difficulty chaining multiple calculation steps in a clean, reliable way For more complex setups (e.g. costing, pricing, production calculations), we often need a multi-step calculation where each step feeds into the next. Doing this with only formula-on-formula quickly becomes fragile. Proposed solution - Add an option on Formula and Lookup fields like: “Create static copy as…” – Text – Number – Currency (if applicable) This new field would: Store the resolved value of the original formula/lookup field, as a normal text/number field, Update automatically whenever the source value changes, Be treated by SmartSuite as a regular non-formula field, so it can be safely used in other formulas without circular reference problems or calculation errors Essentially, it’s a “materialized” version of the field we can chain off. Example use case We calculate a unit cost in a Formula field (involving lookups, conditionals, etc) We then want to: Apply tiered pricing, Add margins, Do rounding logic, Use it again in other apps via lookups If we could convert that formula result into a static Number field that stays in sync, we could build further formulas on it cleanly, without hitting the current limitations of formula-on-formula references.
0
Load More