Resolving Circular Reference Errors in Formulas

System

This discussion was created from comments split from: Enable Iterative Calculation.

Mouhamadine

How to solve the circular program? In excel it is iterative calculation option, but in smartsheet that doesn't seem to exist.

Here is the formula I am trying to use and it is telling me that I have a circular error:

VALUE([Percentages/Indirects]@row) * (VALUE([100% DD]24) + VALUE([100% DD]35))

=SUM([100% DD]25:[100% DD]34)

Michelle Choate 2

Can you provide a screenshot of what you are doing where this is getting a circular error?

Michelle Choate 2

The "#circular reference" error in Smartsheet occurs when a formula refers back to itself either directly or indirectly, causing an infinite loop.

Based on the formula you've provided without knowing the columns it is placed in or its intended functionality, it seems that there might be a direct or indirect reference within the same row that causes the sheet to enter an infinite calculation loop.

Can you provide a screenshot of the columns you are using, and which column you are using the formula in? And maybe more information on the intended purpose of the formula?