Hi Guys,
I need help understanding why my 2 columnsโ (โLine Numberโ and โVariant Keyโ) Initial Value formulas are creating circular definition errorsโฆ
Formula for โLine Numberโ:
Formula of โVariant Keyโ that creates circular error:
The moment I remove LINE 11 in the formula for โVariant Keyโ, the circular error goes away:
Why would โVariant Keyโ LINE 11 be causing a circular error when โVariant Keyโ LINE 4 already ensures a condition which will never conflict with the LINE 2 condition in โLine Numberโ?
Is this because appsheet evaluate circular references without taking conditions into consideration? So that any circular mention between columns will trigger an error? Or am I totally missing some huge error in my expressions?
Yes and yes.
Thanks!
User | Count |
---|---|
42 | |
28 | |
24 | |
22 | |
13 |