data guys - Trying to get D1 data in and I keep getting an error popup that says :
There was a problem
A server error occurred. The page will reload.
Seems to happen almost every time I enter something that causes a recalculation. Anyone else ever see this? I don't have the patience to enter the data if I have to reload the page every time I enter a gap
That seems to be the new norm for Google Docs these days.... I'll usually enter gaps first and then put in the total time. You still get the error but not as often. Either way it's a PITA!
I have resorted to entering the best laps and gaps in an excel file for each race, then copy/paste the column of numbers in to approriate locations, as a range, in the google sheet. It doesn't usually flake out on the best lap numbers but it freaks out every time on the gaps. The difference here is, instead of it reloading 60+ times, it only does it 6. nmcp's solution of holding the total time value out until after the gaps are entered would probably produce the very same results.
Sometimes I even get in 2-3 ranges before the page explodes and has to reload. Sometimes the data I entered is retained, sometimes not.