Edit Google Sheets Scripts
Budget: £10 – £20 GBP
Fixing the code in this formula/script
https://docs.google.com/spreadsheets/d/19HNBigL4DghaariQ7uwXjIeufGsp2Gb5rUCf7s4JuJ4/edit?usp=sharing
there is a script running on this google sheet that calculates 3 columns, mileage, driving time and URL of the journey - the problem is this, every time there is a new row entry in the sheet the script unnecessarily recalculates all the previous calculations, the problem with this is that
1) it doesn't need to be done
2) there is an allowance every month that gets used up with unnecessary calculations so no more can be completed
I need all previous calculations to remain calculated unless there is a change in that individual cell and to keep the rest as it is
https://docs.google.com/spreadsheets/d/19HNBigL4DghaariQ7uwXjIeufGsp2Gb5rUCf7s4JuJ4/edit?usp=sharing
there is a script running on this google sheet that calculates 3 columns, mileage, driving time and URL of the journey - the problem is this, every time there is a new row entry in the sheet the script unnecessarily recalculates all the previous calculations, the problem with this is that
1) it doesn't need to be done
2) there is an allowance every month that gets used up with unnecessary calculations so no more can be completed
I need all previous calculations to remain calculated unless there is a change in that individual cell and to keep the rest as it is