User Posts: Seemanto Saha
0
How to Copy and Paste a Chart in Google Sheets (3 Quick Ways)
0

We often create charts in Google Sheets for better visualization of our data. Sometimes, we require to copy such charts in other parts of the same sheet, in ...

0
How to Use AVERAGEIF Function in Google Sheets (6 Examples)
0

The AVERAGEIF function is basically a combination of the AVERAGE and IF functions. This function is used for returning the average of a range following a ...

0
How to Copy and Paste Formulas in Google Sheets (4 Easy Ways)
0

We often need to apply different formulas in our calculations in Google Sheets. A large spreadsheet can contain hundreds of such calculations, several of which ...

0
How to Get Conditional Notifications in Google Sheets (2 Ways)
0

Large spreadsheets in Google Sheets often require collaboration between dozens of people. Therefore, keeping track of every change made is quite a tedious ...

0
Use AVERAGEIFS with Multiple Criteria in Same Column in Google Sheets
0

The AVERAGEIFS function is similar to the AVERAGEIF function, except for the fact that the AVERAGEIFS function can deal with multiple mutually inclusive ...

0
How to Create a Search Box in Google Sheets (4 Easy Methods)
0

Creating a search box in Google Sheets is helpful for searching for a special piece of information in your spreadsheet and extracting the results in a quick ...

0
How to Remove Both Duplicates in Google Sheets (2 Easy Ways)
0

Removing duplicates is a common task in Google Sheets or Excel operations. But, the first occurrence of each duplicate generally remains when we use the Remove ...

0
How to Use TRIM Function in Google Sheets (4 Easy Examples)
0

Additional spaces are often added to the text when we copy or import text in Google Sheets. These additional spaces can cause trouble in function execution. An ...

0
How to Copy and Paste Multiple Columns in Google Sheets
0

Users often need to Copy and Paste data from one cell to another while using Google Sheets or Excel. Copying and then pasting one cell/row/column is quite easy ...

0
How to Use SUM Function in Google Sheets (6 Practical Examples)
0

Adding some cells from a row, column or array is one of the most common things one can do in Google Sheets. The SUM function in Google Sheets can be utilized ...

0
How to Highlight a Row in Google Sheets (3 Quick Methods)
0

It takes a lot of time to interpret Google Sheets with too much data. One simple solution to this problem is highlighting the important information so it can ...

0
How to Copy Conditional Formatting to Other Cells in Google Sheets
0

Conditional Formatting is used to set predefined conditions and highlight the relevant data. Different color formats of this tool help us reading and analyzing ...

0
Dependent Drop Down List for Entire Column in Google Sheets
0

A dependent drop down list is used when one wants to show only relevant information for subsequent drop downs. While there are a few helpful ways of creating a ...

0
How to Insert Delta Symbol in Google Sheets (4 Easy Methods)
0

The Greek symbol Delta (upper case Δ, lower case δ) is heavily used in the fields of science, mathematics, and finance. Hence, the symbol is often needed in ...

0
How to Create Dependent Drop Down List in Google Sheets
0

A dependent drop down list is used when one wants to show only relevant information for subsequent dropdowns. It is also known as a dynamic dropdown list. ...

Browsing All Comments By: Seemanto Saha
  1. Hello Alan,
    Thanks for your query. I understand that you want to notify a group of people using Email notifications when any edit is made to your Google Sheets. We can accomplish this using an Apps Script code and setting a Google Sheets On Edit trigger.
    Consider the following spreadsheet with multiple worksheets. To enter the Apps Script code in this spreadsheet, click the Extensions tab and select the Apps Script command.
    Opening Apps Script Editor
    As a result, a new tab like the following will appear in your browser.
    Apps Script Editor
    Enter a project name >> replace the default function with the following code >> click the Save button >> click the Trigger command from the left-side pane.
    Apps Script Code

    function onEdit(e){
      var ss = SpreadsheetApp.getActiveSpreadsheet();
      var ws =ss.getActiveSheet();
    
      var range = e.range;
      var oldValue = e.oldValue;
      var newValue = ss.getActiveCell().getValue();
    
      if (oldValue === "" && newValue === ""){
        return;
      }
    
      if (oldValue === newValue){
        return;
      }
    
      var cellAddress = ws.getActiveCell().getA1Notation();
      var editor = Session.getActiveUser().getEmail();
     
      var recipient = "[email protected], [email protected]";
      var sub = "Cell Modification";
      var body = "Modified Spreadsheet: " + ss.getName() + "\nModified Sheet: "+ ws.getSheetName() + "\nEdited Cell: " + cellAddress + "\nEdited by: " + editor + "\nPrevious Value: " + oldValue + "\nCurrent Value: "+ newValue;
    
      MailApp.sendEmail(
        recipient,
        sub,
        body
      );
    }
    

    Consequently, you will get the Trigger options. Click on the Add Trigger button.
    Trigger Options
    This will open the Add Trigger dialog box. Set the Choose which function to run option to OnEdit (i.e. your current function) >> set the Select the event source option to From spreadsheet >> set the Select event type option to On edit >> set the Failure notification settings option to Notify me immediately >> click the Save button.
    Setting Trigger Options
    Click the Editor command from the left-side pane and then click the Run button from the editor.
    Running the Script
    Note:
    1) When you run the code for the first time, you must review permissions for authorizing Google Sheets to use your Google Account to run this script.
    2) You may get an error message when you run the above code. This is normal as you have run the script but no change hasn’t occurred to your spreadsheet. When any change occurs in your spreadsheet, this script will run automatically from now on.
    Now, make any changes to your spreadsheet. In the Research Data worksheet, I have changed Cell F7’s value from Planning to Completed.
    Editing Spreadsheet
    As a result, each person whose email address was included in the Apps Script code will receive an email like the following:
    Emails Sent to Multiple Users
    And that’s how you can send email notifications to multiple people for any edit in your worksheet. Let us know your feedback on the solution. The Google Sheets used for this solution is linked below:
    Google Sheets Notify Multiple Users Using Apps Script

    Regards,
    Seemanto Saha
    OfficeWheel

OfficeWheel
Logo