enter image description here

This formula is working fine, but I need to add in other teams into Column A. I would need to return ATT SLC, ATT Orem, and ATT Scottsdale within this same range, but I'm not sure the language to use to extend the return values

Hopefully the image is readable, if not here is the query I'm working on

=query(importrange("Google Doc URL","Total Summary!A:K"),"where Col1='ATT SLC'")

Again I think it would go something like this, ("Where Col1='ATT SLC','ATT Orem' etc) to get more than one team on a single import.


1 Answer 1


=QUERY(IMPORTRANGE("key/url", "Total Summary!A:K"), "where Col1='ATT SLC' 
                                                        or Col1='ATT Orem' 
                                                        or Col1='ATT Scottsdale'")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.