1

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.

Thanks for looking! Dylan

0

=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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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