Hal is correct. The "standard" approach in Numbers is to use a hidden column or even have an entirely separate sheet and/or table that holds the necessary data.

I can imagine times when circular references are the desirable way to go, but they still are "bad programming". You should not rely on the software developer to resolve the problem.

On a Mac since 1984.
Currently: 24" M1 iMac, M2 Pro Mac mini with 27" BenQ monitor, M2 Macbook Air, MacOS 14.x; iPhones, iPods (yes, still) and iPads.