I currently have an import range set up in my google sheet calling data using one column, but I would like for it to look at two columns in combination to query the information.
Right now I have:
=QUERY(importrange(“URL”,“Name of Sheet A:BI”), “select * where Col30 contains ‘Yes’”)
I would for it to also look at Col62 for the word Complete.
When I added Col62 contains ‘Complete’ I got an error. Am I doing something wrong?