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
Asked
Viewed
19 times
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.
asked 1 hour ago
doubleunary is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
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.
answered 1 hour ago
doubleunary is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
