Resolving Circular Reference Errors in Formulas
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)
-
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! Book time with me here: https://calendly.com/michelle-choate
-
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! Book time with me here: https://calendly.com/michelle-choate
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!