You can change a spreadsheet’s locale, time zone, calculation settings and functions language in Google Sheets.
When you make a change, it changes for the entire spreadsheet. Everyone working on it will see the changes, regardless of their location.
To change your sheet’s location and calculation settings, open it in Google Sheets on your computer.