A value in a cell that changes automatically (using Google Finance), I want to record the lowest value in another cell.

  • Both Excel and Google Sheets have functions like MIN and MAX to find the smallest and highest number in a range. Jun 8, 2021 at 18:57

1 Answer 1


You cannot create a permanent snapshot of a cell value with a spreadsheet formula, so you will have to use a script.

See the appendValuesToArchiveSheet script for one possible solution. You can use it to copy the value in the cell in another sheet in a log file of sorts on an hourly or daily basis and then apply min() function to get the lowest value.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.