Previous Days Value

I have a score column that is automatically updating from a google sheet every 20 mins. I want to have another column that shows the score column value from the previous day at 9am. It would then update daily. Is this possible?

If you use Google App Script, ya. If I understand fully correctly, you can set a trigger that runs the script every day at 9:00am to save the value to a column of your choosing.

1 Like