An easy way to deal with Google Apps Script’s 6-minute limit

About the 6-minute limit Google Apps Script is handy, and it will help you a lot in your work. However, as you use it, you may hit a big wall. That is the six-minute limit on execution time. As the official documentation states, the maximum allowed time per execution of Google Apps Script is 6Continue reading “An easy way to deal with Google Apps Script’s 6-minute limit”

How can older people use Google Drive and Google Sheets mobile apps well?

Google Drive and Google Sheets are fantastic apps for small businesses and non-profit organizations because these apps give us the benefits of sharing storage and accessing databases concurrently from each remote location, and most importantly, they are free! For ordinary users, it is not difficult to use these apps, but what about older people? IContinue reading “How can older people use Google Drive and Google Sheets mobile apps well?”

Tips: How to create a drop-down list that excludes values that have already been entered

Google Sheets has a useful feature called “Data Validation” that limits user input to acceptable limits. If you set its “Criteria” to “List from a range,” the target cells will show a drop-down list that lists up the values that are included in the range you set. However, sometimes you might want to restrict theContinue reading “Tips: How to create a drop-down list that excludes values that have already been entered”

How to move to the last selected row when you open Google Sheets.

Google Sheets is versatile. I use it for data storage, programming, and also for writing my work journals. When you use it as a work journal, you will usually freeze the sheet’s top part since the header will be hidden if there are many records. Like this; However, the more records you have, the moreContinue reading “How to move to the last selected row when you open Google Sheets.”

GAS-Terminal: Environment for smart execution of Google Apps Script

Running GAS is a pain. Do you like Google Apps Script(GAS)? Me too! 👍I’ve written a lot of GASs to run system processes and maintain data. Most of them are run by various triggers automatically, but sometimes I need to run some scripts by hand. Then I’ll be reminded that “Running GAS is a pain!”Continue reading “GAS-Terminal: Environment for smart execution of Google Apps Script”

6 Reasons Why Small Business IT Staff Should Switch from Excel to Google Sheets — Part2

A feeling of an IT staff in a small team If you are an IT staff in a small business, maybe you’ve already been considering what software you should use for document management as well as I did. In many companies that normally use Windows PCs, the employees, especially IT staff, use Microsoft Excel. SinceContinue reading “6 Reasons Why Small Business IT Staff Should Switch from Excel to Google Sheets — Part2”

6 Reasons Why Small Business IT Staff Should Switch from Excel to Google Sheets — Part1

A feeling of an IT staff in a small team If you are an IT staff in a small business, maybe you’ve already been considering what software you should use for document management as well as I did.  In many companies that normally use Windows PCs, the employees, especially IT staff, use Microsoft Excel. SinceContinue reading “6 Reasons Why Small Business IT Staff Should Switch from Excel to Google Sheets — Part1”

Create your website with WordPress.com
Get started