# Question to the google sheet gurus

**URL:** <https://community.glideapps.com/t/question-to-the-google-sheet-gurus/22298>\
**Category:** Ask for Help\
**Created:** [February 5, 2021, 6:33pm UTC](https://community.glideapps.com/t/question-to-the-google-sheet-gurus/22298 "2021-02-05T18:33:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![pushingpandas](https://avatars.discourse-cdn.com/v4/letter/p/87869e/32.png) [@pushingpandas](https://community.glideapps.com/u/pushingpandas)\
**Post date:** [February 5, 2021, 6:33pm UTC](https://community.glideapps.com/t/question-to-the-google-sheet-gurus/22298/1 "2021-02-05T18:33:38Z")

</div>

Hello, Iam following the amazing Gamify Tutorial from Bob on youtube. One problem now, Iam using european version of google due my location in germany and the formula does not work that why. I had the problem before with a other formular where I had to change all “,” to a “;” to make it work.

Now this formula “={“nonCardPackRowNumber”;ArrayFormula(ifna(vlookup(row(H2:H),{filter(row(H2:H),H2:H\<\>”“),sequence(counta(H2:H),1)},2,0)))}” I tried the same by switching “,” to “;” but that did not work in that case ☹

Anybody know what to do?

Here the video [https://www.youtube.com/watch?v=eF\_lxHVd5NY](https://www.youtube.com/watch?v=eF_lxHVd5NY)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 5, 2021, 6:43pm UTC](https://community.glideapps.com/t/question-to-the-google-sheet-gurus/22298/2 "2021-02-05T18:43:08Z")

</div>

> [@pushingpandas](#):
>
> “={“nonCardPackRowNumber”;ArrayFormula(ifna(vlookup(row(H2:H),{filter(row(H2:H),H2:H\<\>”“),sequence(counta(H2:H),1)},2,0)))}”

Check your double-quotes, some of them look like “smart quotes”.

```auto
={"nonCardPackRowNumber";ArrayFormula(ifna(vlookup(row(H2:H),{filter(row(H2:H),H2:H<>""),sequence(counta(H2:H),1)},2,0)))}"

```

Try copy/pasting the above. It’s exactly the same formula, with the smart quotes replaced.

---

<div class="post-metadata">

**Author:** ![pushingpandas](https://avatars.discourse-cdn.com/v4/letter/p/87869e/32.png) [@pushingpandas](https://community.glideapps.com/u/pushingpandas)\
**Post date:** [February 5, 2021, 7:01pm UTC](https://community.glideapps.com/t/question-to-the-google-sheet-gurus/22298/3 "2021-02-05T19:01:17Z")

</div>

> [@Darren\_Murphy](#):
>
> ```auto
> ={"nonCardPackRowNumber";ArrayFormula(ifna(vlookup(row(H2:H),{filter(row(H2:H),H2:H<>""),sequence(counta(H2:H),1)},2,0)))}"
> 
> ```

Thank you that worked. Somehow its not the same result like in the video. I have now numbers in all slots and the packslots should be empty.

 ![sheet](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2e965f8edc1c36dec8d0ab1e159c0e4e784516e2.jpeg)

---

<div class="post-metadata">

**Author:** ![pushingpandas](https://avatars.discourse-cdn.com/v4/letter/p/87869e/32.png) [@pushingpandas](https://community.glideapps.com/u/pushingpandas)\
**Post date:** [February 5, 2021, 7:01pm UTC](https://community.glideapps.com/t/question-to-the-google-sheet-gurus/22298/4 "2021-02-05T19:01:48Z")

</div>

![sheete2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/1/e14f92f94014781d5513bb52ef99bf1e408f7a02.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 6, 2021, 2:02am UTC](https://community.glideapps.com/t/question-to-the-google-sheet-gurus/22298/5 "2021-02-06T02:02:03Z")

</div>

I’m not familiar with the tutorial or the app, so this is just a guess based on what I see in your screen shots. But, what happens if you use this:

```auto
={"nonCardPackRowNumber";ArrayFormula(ifna(vlookup(row(H2:H),{filter(row(H2:H),H2:H=true),sequence(counta(H2:H),1)},2,0)))}"

```

?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 6, 2021, 2:27am UTC](https://community.glideapps.com/t/question-to-the-google-sheet-gurus/22298/6 "2021-02-06T02:27:46Z")

</div>

If you watch “episode” 11.5, you’ll see that I no longer use spreadsheet formulas in my “card pack” functionality for this very reason.