I am having an issue with queries.
I track spotify data and want to find the top song for each album so I use a formula something like this:
=query('album daily'!$V5:$Y11,"Select V,Y order by Y desc limit 1")
The 'album daily' spreadsheet is dynamic and changes everyday.
This formula works and grabs the correct data when used. However, I am sometimes having an issue that it is not updating automatically. I have to manually delete the formula and copy & paste it again and then it works. This unfortunately takes me too much time.
How do I combat this glitch? Do I have to regularly clear my cache?