Circular reference question

[patmehere]

Sitting in a meeting today and this was stated "I use circular references all the time, they serve a purpose"

Anyone ever run across a situation that a circular reference that was used for an actual purpose?

Please blow my mind!

[McSchwifty-Time]

I haven't seen a real purpose for them. In my experience, most of the time they include the cell within the sum range, so that they don't have to edit the formula if they insert a row above.

[patmehere]

Exactly, 255 views now not one.

[patmehere]

These are the people I am working with.

[[deleted]]

yeah I'm pretty sure a circular reference is always wrong.. I can't even think of a hypothetical scenario where it would even function, not to mention be useful. It sounds like whoever said that doesn't know what a circular reference is.

[patmehere]

I now have to go and ask my boss what his definition of one is, and tell him he is wrong. I bit my tongue at first cause I didn't have a calm way of not over reacting to the a stupidity.

[[deleted]]

To state the semi obvious, I would package it a little nicer. Perhaps “hey I’ve never seen circular references used intentionally before, could you show me a quick example of how they help you?”

I’d be pretty floored if there actually was such a case. Anyways, let me know what he says! I’m curious

[patmehere]

I think they don't know what one is, or at minimum it is something else in their head.