I GOT IT!
now it shows like it should.
I am from Germany and of course I use the German version of Sheets. When I went into the settings and changed the program as well as the functions to English, it suddenly worked.
Who would have thought that xD
Thanks anyway for the help!