I can't figure out why my custom calculation isn't updating...? If I go from left to right then the custom calculations work fine but if I bounce in between cells onthe paper then the % of inventory stops updating... as you can see here I went back and deleted the middle room pool group number (which was 5) but the percent remained 45....? Any help? I've read about setting the calculation order but what if you bounce around on the paper? How can I get it to always recalculate....Thanks in advance!
Check the calculation order. The calculation order is completely independent of the order of entered data. So it doesn't matter if you skip around.
If that's not the issue, then there may be an error causing the issue. Look in the Console window to see if there are any messages.
In field calculation order field "Z" should be second to last, and
"INVENTORY OFFERED" should be last field (on the bottom) and field "U" should be before "V".
Also in "INVENTORY OFFERED" you didn't check for 0 'if(v2==0)'
You are missing an "else" in "INVENTORY OFFERED" field script.
if (v2==0) event.value = "";
event.value = v1/v2;
You.Are.Awesome! I totally missed that!!! Thanks!