Resolving Circular Reference Errors in Formulas

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

Answers

  • 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
    Michelle Choate 2 ✭✭✭✭✭✭

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

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with!

  • Michelle Choate 2
    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?

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!