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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.