# IMPORTRANGE() with Filter

**URL:** <https://community.tiller.com/t/importrange-with-filter/4904>\
**Category:** Ask Anything\
**Created:** [July 26, 2020, 5:44pm UTC](https://community.tiller.com/t/importrange-with-filter/4904 "2020-07-26T17:44:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nataliapinzon](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/nataliapinzon/32/4059_2.png) [@nataliapinzon](https://community.tiller.com/u/nataliapinzon)\
**Post date:** [July 26, 2020, 5:44pm UTC](https://community.tiller.com/t/importrange-with-filter/4904/1 "2020-07-26T17:44:18Z")

</div>

I’m Filtering my importrange using the method tiller outlined in “filter-your-importrange-data-in-google-sheets” exactly. However, it is producing a “formula parse error”

I tested that function without the filter (importrange only) and it works fine. The sheets are connected. I think there is something wrong with the formula

Thank you for your help

---

<div class="post-metadata">

**Author:** ![jono](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jono/32/283_2.png) [@jono](https://community.tiller.com/u/jono)\
**Post date:** [July 27, 2020, 7:06pm UTC](https://community.tiller.com/t/importrange-with-filter/4904/2 "2020-07-27T19:06:18Z")

</div>

Can you share the formula ? (Change the spreadsheet ID , the long series of numbers and letters). You might have an extra " or , in the wrong place.

---

<div class="post-metadata">

**Author:** ![nataliapinzon](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/nataliapinzon/32/4059_2.png) [@nataliapinzon](https://community.tiller.com/u/nataliapinzon)\
**Post date:** [July 27, 2020, 7:49pm UTC](https://community.tiller.com/t/importrange-with-filter/4904/3 "2020-07-27T19:49:00Z")

</div>

=FILTER(IMPORTRANGE(“SHEET ID,”Transactions!A:L”), INDEX(IMPORTRANGE(“SHEET ID,”Transactions!A:L”),0,4)=”Groceries”)

---

<div class="post-metadata">

**Author:** ![jono](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jono/32/283_2.png) [@jono](https://community.tiller.com/u/jono)\
**Post date:** [July 27, 2020, 8:04pm UTC](https://community.tiller.com/t/importrange-with-filter/4904/4 "2020-07-27T20:04:23Z")

</div>

You need to surround both sides of the SHEET ID with ".  
In your example, you only have " at the start of the SHEET ID. The double-quotes need to be on the end of both SHEET ID references too.

Also, sometimes copying single and double quotes can be a problem, if you browser turns them into starting and ending quotes.

What you copied uses starting and ending quote (not sure if that’s just in the Community or also in your spreadsheet too?)

=FILTER(IMPORTRANGE(“SHEET ID,”Transactions!A:L”), INDEX(IMPORTRANGE(“SHEET ID,”Transactions!A:L”),0,4)=”Groceries”)

They should look like this: (regular double-quotes and quotes added after SHEET ID):

`=FILTER(IMPORTRANGE("SHEET ID","Transactions!A:L"), INDEX(IMPORTRANGE("SHEET ID","Transactions!A:L"),0,4)="Groceries")`

---

<div class="post-metadata">

**Author:** ![nataliapinzon](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/nataliapinzon/32/4059_2.png) [@nataliapinzon](https://community.tiller.com/u/nataliapinzon)\
**Post date:** [July 29, 2020, 12:34am UTC](https://community.tiller.com/t/importrange-with-filter/4904/5 "2020-07-29T00:34:23Z")

</div>

It worked! thank you so much