I'm looking for help editing a Google Sheets formula. I want the formula to Import Range from another worksheet where value equals a specified cell. I can only make the where in the formula equal a hard-coded text. Can someone help?
=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1BoIre_wWE6yfiFvLseWGn3XNqK4gUS2wqdVenR32q2M/edit#gid=20780806", "CM!A2:G3000"),"SELECT Col1,Col5 WHERE (Col3 = 'Cross Fit')")
I want it to reference cell C1 instead of "Cross Fit"