Post by account_disabled on Jan 24, 2024 6:17:09 GMT
Alexander Maksimenyuk, founder and CVO of Ringostat, has been actively working with tables since his university days. Therefore, people turn to him for advice on how to write a formula or process data. According to him, the most common mistake is making too “heavy” solutions to problems that can be solved more simply. Or when something is done manually that can be automated. For those who work with Google spreadsheets and would like to do it better, Alexander has prepared a selection of tips - from simple to complex. Reading time 14 minutes English interface and American locale Data verification (validation) Naming Decor Working with formulas General tips for beginners Formula modifiers ARRAYFORMULA Formulas that are important to remember Useful tips If the document is heavy and difficult to work with Limits Here we will not discuss how to create a Google Sheet or enter information into it. Instructions on this topic can be easily found.
In this Fax Lists article we will talk about non-obvious life hacks when working with Google Sheets. English interface and American locale The Russian-language interface is clearer for most, but there is a catch in it - the separator between function arguments is a semicolon. In English there is a comma. Moreover, all the solutions that we will talk about below are configured with commas. The locale also affects the fractional separator in numbers - a dot in the English version, a comma in the Russian version. This is what causes problems when importing, for example, from a database. Why the American locale: it will definitely have dots, it is native and the most common - so it has a minimum of bugs.
But there are a couple of drawbacks: the date is presented in the format month, day, year, and the separator is a slash. what is a google spreadsheet Data verification (validation) It is especially important when different employees manually enter data into a document, which means they can make mistakes. Validation is configured in the Data - Data Validation section and comes in two types: weak validation - if you enter data in an incorrect format, a window with an error message will appear; strict validation - incorrect data cannot be entered at all. Google Sheet, selection of validation - Google Sheets Setting up validation Naming Name the table as clearly as possible - not only for you, but also for those people to whom you will give access to it.
In this Fax Lists article we will talk about non-obvious life hacks when working with Google Sheets. English interface and American locale The Russian-language interface is clearer for most, but there is a catch in it - the separator between function arguments is a semicolon. In English there is a comma. Moreover, all the solutions that we will talk about below are configured with commas. The locale also affects the fractional separator in numbers - a dot in the English version, a comma in the Russian version. This is what causes problems when importing, for example, from a database. Why the American locale: it will definitely have dots, it is native and the most common - so it has a minimum of bugs.
But there are a couple of drawbacks: the date is presented in the format month, day, year, and the separator is a slash. what is a google spreadsheet Data verification (validation) It is especially important when different employees manually enter data into a document, which means they can make mistakes. Validation is configured in the Data - Data Validation section and comes in two types: weak validation - if you enter data in an incorrect format, a window with an error message will appear; strict validation - incorrect data cannot be entered at all. Google Sheet, selection of validation - Google Sheets Setting up validation Naming Name the table as clearly as possible - not only for you, but also for those people to whom you will give access to it.