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!
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!