{"id":7544,"date":"2017-12-06T15:00:44","date_gmt":"2017-12-06T14:00:44","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=7544"},"modified":"2017-12-06T15:00:44","modified_gmt":"2017-12-06T14:00:44","slug":"location-and-timezone-affect-your-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-features\/location-and-timezone-affect-your-google-sheets\/","title":{"rendered":"Como a localiza\u00e7\u00e3o e o fuso hor\u00e1rio podem afetar seu Planilhas Google"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Unlike other desktop-based spreadsheets,\u00a0<\/span>Google Sheets<\/a>\u00a0<\/span>is a cloud-based application that is ubiquitous. It is location and device independent. All we need is a browser and an Internet connection. With such a grand proposition of being able to serve people all over the world, comes certain challenges. Not surprisingly, Google Sheets handles them pretty well. In this article, we demonstrate how can location and timezone affect Google Sheets.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Why should location and timezone affect Google Sheets?<\/h3>\n

Because not all the geographical locations have the same language, currency, date and numeric notations, etc. Therefore, users preferences will align to the geography they are present in. To understand how Google Sheets intelligently caters to its global users, consider the following snapshot.<\/p>\n

Example<\/strong><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/location-and-timezone-affect-Google-Sheets-1.png” alt=”location and timezone affect Google Sheets 1″ title_text=”location and timezone affect Google Sheets 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

In the data formatting options available, we see the dollar ($) is the preset currency. The date format is in M\/DD\/YYYY format. If we navigate to\u00a0<\/span>File > Spreadsheet settings<\/strong>, we notice the location is United States. No wonder, the way we see data formats are in line with those of United States notations.<\/p>\n

Example<\/strong><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/location-and-timezone-affect-Google-Sheets-2.png” alt=”location and timezone affect Google Sheets 2″ title_text=”location and timezone affect Google Sheets 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

If the location and language preferences were Spain and Espa\u00f1ol respectively, we will see all the data representation aligns with that of Spanish notations. Similarly, Google Sheets customized this experience across geographies.<\/p>\n

Not just that, Google Sheets even manages the built-in functions in the preferred language. In the below screenshot, the first three formulas are Spanish representations of English counterparts SUM, AVERAGE, and COUNT. We\u2019ll also notice that the delimiter changes to semi-colon from comma, which also applies to formula delimiters as well.<\/p>\n

Example<\/strong><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/location-and-timezone-affect-Google-Sheets-3.png” alt=”location and timezone affect Google Sheets 3″ title_text=”location and timezone affect Google Sheets 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

If we prefer, we can configure Google Sheets to handle functions only in English language. To do so, navigate to\u00a0<\/span>File > Spreadsheet<\/strong>\u00a0<\/span>settings, and check the box (highlighted) to true.<\/p>\n

Example<\/strong><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/location-and-timezone-affect-Google-Sheets-4.png” alt=”location and timezone affect Google Sheets 4″ title_text=”location and timezone affect Google Sheets 4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Congratulations! We just explored how the changes in location and timezone affect Google Sheets.<\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Unlike other desktop-based spreadsheets,\u00a0Google Sheets\u00a0is a cloud-based application that is ubiquitous. It is location and device independent. All we need is a browser and an Internet connection. With such a grand proposition of being able to serve people all over the world, comes certain challenges. Not surprisingly, Google Sheets handles them pretty well. In this […]<\/p>\n","protected":false},"author":40,"featured_media":7545,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Unlike other desktop-based spreadsheets, Google Sheets is a cloud-based application that is ubiquitous. It is location and device independent. All we need is a browser and an Internet connection. With such a grand proposition of being able to serve people all over the world, comes certain challenges. Not surprisingly, Google Sheets handles them pretty well. In this article, we demonstrate how can location and timezone affect Google Sheets.\n

Why should location and timezone affect Google Sheets?<\/h3>\nBecause not all the geographical locations have the same language, currency, date and numeric notations etc. Therefore, users preferences will align to the geography they are present in. To understand how Google Sheets intelligently caters to its global users, consider the following snapshot.\n\nExample<\/strong> \"How\n\nIn the data formatting options available, we see the dollar ($) is the preset currency. The date format is in M\/DD\/YYYY format. If we navigate to File > Spreadsheet settings<\/strong>, we notice the location is United States. No wonder, the way we see data formats are in line with those of United States notations.\n\nExample<\/strong> \"How\n\nIf the location and language preferences were Spain and Espa\u00f1ol respectively, we will see all the data representation aligns with that of Spanish notations. Similarly, Google Sheets customized this experience across geographies.\n\nNot just that, Google Sheets even manages the built-in functions in the preferred language. In the below screenshot, the first three formulas are Spanish representations of English counterparts SUM, AVERAGE, and COUNT. We'll also notice that the delimiter changes to semi-colon from comma, which also applies to formula delimiters as well.\n\nExample<\/strong> \"How\n\nIf we prefer, we can configure Google Sheets to handle functions only in English language. To do so, navigate to File > Spreadsheet<\/strong> settings, and check the box (highlighted) to true.\n\nExample<\/strong> \"How\n\nCongratulations! We just explored how will the changes in location and timezone affect Google Sheets.\n\n ","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-7544","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/7544","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=7544"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/7544\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/7545"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=7544"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=7544"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=7544"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}