Just discovered a HUGE issue that is going to create hours of work fixing.
When adding a row, formulas in rows below it do not change.
eg. when adding a new row between 99 and 100, formulas that referenced the old 100 still reference 100 after the row add.
BUT when deleting the new row, the formulas follow theoretically ‘correct behavior’ and revert back to reference 99.
So when adding a row, the formulas don’t work, and when deleting the row, the formulas still don’t work.
Really hoping that you guys can find a way to revert this back for me, and to fix it going forward ASAP.