Circular Reference Won't Go Away

eceisin ✭✭✭
edited 12/09/19 in Formulas and Functions



I'm working on fairly large sheets that reference many other sheets.  My main summary sheet is doing SUMIFS formulas to summarize and sum to a higher level.  The summary sheet column is showing a Circular Reference error.  I found the error on my raw sheet and corrected.  However the main summary file still shows a circular reference error that won't go away even after re-doing the reference and formula.  Again, the sheet it is referencing does not show an error in the column I am summing. Any advice?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!