When adding multiple rows at once using
RowID formula is extremely unreliable.
Not only does it work after a delay, but it also appears one row at a time.
This means that, if you have other columns dependent on the
RowID formula, the calculating looks something like this:
Add multiple rows --> calculate all formulas --> update RowID of the first row --> recalculate everything --> update RowID of the second row --> recalculate everything -->...
This can create formula chains which takes hours to calculate.
What’s more, because this is a lot of quick formulas instead of a single long one, the
disable calculations buttons doesn’t show up and even hard reloading the tab won’t help you, after the reload it will continue calculating.
A simple workaround would be to create your own id for each row when creating it instead of relying on the
But this is still a huge issue which is hard to debug and can cause an enormous of headache and frustration.
And here is a demo which illustrates what I mean: