I am still learning the way of smartsheet but I do feel that I have a good general understanding of how it works. I am currently struggling with a circular reference that just wont go away. Well sometimes it does.
Here is what happens: I have 2 sheets one sheet is called controls and the other sheet is a summary of all the controls and how they contribute to the business. The circular reference error occurs in my summary sheet when a new control is added. Everything will be fine in the summary sheet with no errors but then the moment after I add a control (using a form) it causes the circular reference error in the summary sheet.
And how I have fixed it every time up till now is by simply deleting on of my calculations in a single cell on the summary sheet and refreshing the sheet after saving. Then I simply paste in the exact same formula in the cell I deleted it from; save and refresh and then everything is fine. I don't understand how and why this happens? Can someone please explain to me why this happens? This error indicates to me that my formulas are not a problem but are only unhappy when a new control is added.
Help Article Resources
Check out the Formula Handbook template!