How to use Substring in Google Apps Script
A simple guide to extracting substring from a cell using Google Apps Script
How to use If Else in Google Apps Script?
A simple guide to using If Else statement in Google Script
Review Permission For Google App Script
To access your Apps Script, go to Extensions -> Apps Script. In order to run your script, you will need to save the project by clicking on the Save button.…