Formula Columns

Platform discussions Special workflows & use cases
1

Does Monday.com not allow us to create formulas using values from other calculated formula columns?

Formula in Use:
CONCATENATE(ROUND((({Total 2021} - {Total 2020}) / {Winter 2020}) * 100, 2), “%”)

Error Symbols:

image
image1505×110 15.2 KB

2

No, Monday.com does not allow formula columns to reference other formula columns directly. This limitation exists because formula columns dynamically calculate their values based on the underlying data, and allowing formulas to reference each other could create circular dependencies or performance issues.

Why Your Formula Isn’t Working:

The {Total 2021}, {Total 2020}, and {Winter 2020} fields you’re referencing must be either:

  1. Native columns in your board (like numbers, dates, text, etc.).
  2. Values calculated outside of formula columns.

If any of those inputs are themselves formula columns, the formula will fail.

Workarounds:

  1. Replace Calculated Values with Native Values
    If possible, replicate the calculations in {Total 2021}, {Total 2020}, or {Winter 2020} using base column values, so your formula can work directly with those inputs.

  2. Use the General Caster App or Auto Boost (if applicable)
    General Caster is a third-party app that can handle advanced formulas, including chaining formula column outputs. It can write results back into text or number columns for further use.

  3. Manual Calculation in Other Tools
    Perform the intermediate calculations externally (e.g., in Excel or Google Sheets) and import the results into native columns in Monday.com.

Example Adjustment:

If {Total 2021} = Column A + Column B and {Total 2020} = Column C - Column D, rewrite your formula to:

CONCATENATE(ROUND(((({Column A} + {Column B}) - ({Column C} - {Column D})) / {Winter 2020}) * 100, 2), “%”)

By using the base columns directly, you bypass the limitation of referencing other formula columns.

3

Thanks for confirming and for the solutions!