When I copy to my spreadsheet I get the Error Formula Analysis Error

When I copy to my spreadsheet I get the Error "Formula Analysis Error"

This is because the language set on the Google Spreadsheet is a language other than English. Please try changing the language on the preferred language used in Google Services to English. 

You can follow the instructions on this video to change your language to English.