Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
Anybody can ask a question
Anybody can answer
The best answers are voted up and rise to the top
In my Google Sheet cell D4 contains a number and D9 contains another number. How do I record the difference between these two numbers on a daily basis? I would like each row in the record to show the date and the difference.
To permanently record a value in a log once a day, you will need a script. Try this:
- Insert a formula in say cell D12 that calculates the difference:
=D9 - D4
- Write a script that reads the value in cell D12 and appends it to a log sheet.
- Run the script through an installable trigger that executes once a day.
There is a complete example of how to do this in the appendValuesToArchiveSheet script.