# Insights sheet Errors

**URL:** <https://community.tiller.com/t/insights-sheet-errors/26111>\
**Category:** Google Sheets\
**Created:** [May 15, 2024, 11:12pm UTC](https://community.tiller.com/t/insights-sheet-errors/26111 "2024-05-15T23:12:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ricardosmenezes](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/ricardosmenezes/32/17485_2.png) [@ricardosmenezes](https://community.tiller.com/u/ricardosmenezes)\
**Post date:** [May 15, 2024, 11:12pm UTC](https://community.tiller.com/t/insights-sheet-errors/26111/1 "2024-05-15T23:12:33Z")

</div>

Hi there,

I was trying to configurate the insights sheet, but I keep getting the following error:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/0/4/049b573f401d4535c890b58121dcd97dcdad55f1.png)

Can anybody help me with this. I only change the “,” to “;” because my googlesheet only accepts this (region maybe).

If you need more info, let me know.

Best Regards

---

<div class="post-metadata">

**Author:** ![KyleT](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/kylet/32/13591_2.png) [@KyleT](https://community.tiller.com/u/KyleT)\
**Post date:** [May 16, 2024, 1:17am UTC](https://community.tiller.com/t/insights-sheet-errors/26111/2 "2024-05-16T01:17:48Z")

</div>

Hi @ricardosmenezes - I believe that if you’re in a region that uses decimal comma notation instead of decimal point notation, you would replace commas with semi-colons as you’ve done, with exception of inside curly braces like the first part of this formula. The curly braces { } are used for forming an array and the commas inside there need to be replaced with a backslash .

One other thing you could try is to go to File–\>Settings–\>General–\>Locale and set the Locale for this sheet to your location and (I’m not 100% sure about it and can’t test it myself), but it might change these formula delimiters automatically for you. Hopefully it would, otherwise it seems like a lot of effort would be needed to go manually change all of the formulas. Let us know if you do that and if it works because I couldn’t seem to get a clear answer on that when making a simple Google search.

 ![CleanShot 2024-05-15 at 21.01.34](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/3/e/3ea6cf2a8823bd4e29d0ad1fcc2f6aca32432310.png)

---

<div class="post-metadata">

**Author:** ![KyleT](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/kylet/32/13591_2.png) [@KyleT](https://community.tiller.com/u/KyleT)\
**Post date:** [May 16, 2024, 1:50am UTC](https://community.tiller.com/t/insights-sheet-errors/26111/3 "2024-05-16T01:50:15Z")

</div>

Actually I could test changing the Locale and it seems to automatically correct the delimiters, so hopefully that would resolve the issue.

---

<div class="post-metadata">

**Author:** ![ricardosmenezes](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/ricardosmenezes/32/17485_2.png) [@ricardosmenezes](https://community.tiller.com/u/ricardosmenezes)\
**Post date:** [May 16, 2024, 8:35am UTC](https://community.tiller.com/t/insights-sheet-errors/26111/4 "2024-05-16T08:35:22Z")

</div>

Hi there,

Thank you for you reply!the backlash worked!

good job!