Insights sheet Errors

Hi there,

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

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

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.

1 Like

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

Hi there,

Thank you for you reply!the backlash worked!

good job!

1 Like