I'm trying to create a function on a secondary sheet to monitor the blogs that generate the most traffic. Currently, my secondary sheet contains a formula that displays blogs that have more than 400 views and works: = QUERY ("Raw Data"! A3: AM, "Select * Where AF> 400)
However, I wish to modify this to allow me to simply write in A1 the view threshold I wish to see, which will dictate the entire worksheet without having to change the formula each time, but the formula I thought would work does not mean: = QUERY ("Raw Data"! A3: AM, "Select * Where AF> A1).
What am I doing wrong?