I am trying to figure out how to get Google sheets to only calculate circular dependency when a specific cell is changed. What is happening now is that the calculation occurs every time anything is changed on the sheet.
What is happening now is that if A1 is supposed to add B1 to itself, it works. But, if I then change the value in B2, A1 adds B1 to itself again. Grrr. Very frustrating. Again, I only want A1 to add itself to B1 if B1 is changed.
And yes, I have circular dependency enabled.
Example formula placed in A1: =A1+B1