I'm trying to create a function on a secondary sheet to monitor which of my blogs are getting the most traffic. Currently my secondary sheet has a formula that works to show me blogs that have over 400 views that works: =QUERY('Raw data'!A3:AM,"Select * Where AF > 400)

However, I want to modify this to allow me to simply write in A1 the view threshold I wish to see, that will dictate the entire spreadsheet without having to change the formula each time but the formula I thought would work, doesn't: =QUERY('Raw data'!A3:AM,"Select * Where AF > A1).

What am I doing wrong?

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.