In this video, I show how to refresh formulas automatically in Google Sheets by changing the recalculation settings. By default the settings are set to "on change" but you can change them to "on change and every minute" or "on change and every hour"
Read through the full tutorial here:
https://www.modernschoolbus.com/refre...