Help needed to resolve Circular Definition Error

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”:
Screenshot 2020-08-02 at 01.56.46

Formula of “Variant Key” that creates circular error:
Screenshot 2020-08-02 at 01.51.42

The moment I remove LINE 11 in the formula for “Variant Key”, the circular error goes away:
Screenshot 2020-08-02 at 01.52.57

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!

1 Like