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.
    – Jacob Jan
    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 you have read our privacy policy.

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