Google Sheets "semi-autodata"

If you’re on a premium plan, you can change the goal’s aggregation method to be ‘last’. This would mean that all your datapoints get added to the goal, but only the most recent one counts as far as being-on-the-road is concerned.

Conversely, the API lets you update the value of an existing datapoint. But that requires coding… if you want to see an example, my dailies perl script updates datapoints.

3 Likes