Benefits from New Add-ons in G Sheet

Recently Google came up with new and revolutionary features, which change dynamically with the speed and work style in G sheet. What's new in it..!!

Let's have a quick review:

1.Checkbox

You can add checkboxes to cells in a spreadsheet. Use checkboxes for many purposes, like to track a project, take attendance, and check off your to-do list.

How to Insert checkboxes

1. Open a spreadsheet in Google Sheet.

2. Select the cells you want to have checkboxes.

3. In the menu at the top, click Insert Checkbox.

4. To remove checkboxes, select the checkboxes you want to remove and press Delete.

Example:

2. Script Editors

Google Apps Script is a scripting language based on JavaScript that lets you do new and cool things with G Suite products like Docs, Sheets, Slides, and Forms. There's nothing to install—we give you a code editor right in your browser, and your scripts run on Google's servers.

Steps to use the Script editor functions:

1. On your computer, open a spreadsheet in Google Sheets.

2. Select Tools

3. Select Script editor

It will redirect to the new page as https://script.google.com/a/domain.com/.

Basically here we can edit the code and set new function in G sheet. This code is based on javascript. So for those who are good in programming can design their own function in G sheet.

In our example, I had set a function to remove duplicates in G sheet.

Once the code is saved in the file, select run button to run the script and get the output in G sheet.

Note: It will ask the user permission before you run any code. You have to confirm the email id before you run the first program.

1. Macros.

Google Sheet lets you record macros that duplicate a specific series of UI interactions that you define. Once you've recorded a macro, you can link it to a keyboard shortcut in the form of Ctrl+Alt+Shift+Number.

Let's check out step wise with the example of salary and increment process.

If you have the format of data constant with the changes in context you can use the macros to run the same functionality

1. Select tools

2. Select macros

3. Select record macros

4. Next functions you will do, will be recorded

Now we add a column and use add functionality with column B.

Then Save tab

For the next time with different data you can use the same function without applying the formulas again.

For new set of data, now just go to macros and select macros.

Output of Macros.

To learn more about these new features and Script code you can refer to the tutorial from https://developers.google.com/apps-script/guides/sheets/functions.