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.