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
4 Likes
Thank you, this is what I need!
2 Likes