What is #circular! in Google Sheets?
#CIRCULAR! means a formula chain loops back on itself. Sheets blocks the loop until you break the cycle or enable iterative calculation for intentional circular models.
When to use it
Use error messages as a checklist when a formula returns an unexpected result or blocks a dependent report.
When to skip it
Do not treat every warning as fatal; some loading or circular notices are expected during imports or iterative models.
Better Sheets resources
Related Tutorials
Watch how #CIRCULAR! works
10 Google Sheets I Wish Someone Would Make
Ali Abdaal's Google Sheet | Year at a Glance
Great Sheets! Corona Hiring Sheet
Ultimate Checklist in Google Sheets
Related blog posts
Guides that explain #CIRCULAR! in more depth.
How to Gain Confidence in Google Sheets
Building confidence in Google Sheets, and yourself is essential. It's benefits include: streamlining your workflow, ensuring data accuracy, and maximizing your productivity. If you’ve ever felt overwhelmed or unsure about using Google Sheets, this guide is here to help. Let’s explore some practical tips and strategies to boost your confidence and become a Google Sheets pro. I'll show you where you can find help inside and outside of Google Sheets. 👍Better Sheets Members can email me anytim...
Read post →Revolutionize Your CRM: 3 Game-Changing Google Sheet Formulas!
CRM software is essential for any business looking to increase revenue and build relationships with clients. Many small businesses are looking for their first piece of software to go from spreadsheets to something else. But what if I told you, you could just make your spreadsheets better.
Read post →How To Make That Viral Growing Plant Progress Chart
You might have seen a viral TikTok where there is a progress bar and a growing sort of garden of flowers or potted plant that's growing as you check off these task bars tasks. So I want to walk through what this formula, the combination is how it's really cool it
Read post →Related terms
Circular reference
A circular reference happens when a formula chain loops back to the cell you are editing, directly or through other cells. Google Sheets normally blocks this with a warning and may show zero or an error until you break the loop or enable iterative calculation. Most circles in real files are mistakes, not intentional models.
Read guide →Formula errors in Google Sheets
Formula errors are typed messages in cells when something prevents a valid result. Each code points to a different failure mode: bad reference, missing lookup, type mismatch, divide by zero, unknown name, or blocked array spill. Learning the vocabulary speeds debugging and keeps dashboards trustworthy for decision makers.
Read guide →#REF! error
#REF! means a formula references a cell or range that no longer exists. Common causes include deleted rows or columns, removed sheets, broken IMPORTRANGE, or cut-paste that orphaned an address. The error spreads to every dependent formula until you repair the link.
Read guide →#VALUE! error
#VALUE! means Google Sheets cannot interpret an argument as the type the function expects. Common causes include text in a math formula, invalid dates, wrong delimiter locale, or passing a range where a scalar is required.
Read guide →#NAME? error
#NAME? means Google Sheets does not recognize a name in your formula. That can be a misspelled function, a named range that does not exist, text used without quotes, or a function name from the wrong language locale.
Read guide →Done reading about #CIRCULAR!?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.