CircularRefError?

Why the error happens? And how to solve this problem?
I want the result is 3 in the picture 4, not “CircularRefError”

1 Like

Hi @superstar123, try using value instead of $B. Normally cells aren’t allowed to refer to themselves, but for trigger formulas they have special access to the value the user wanted to enter as value. There is some discussion of this here: Intro to formulas - Grist Help Center

3 Likes

Thank you, this is what I need!

2 Likes