Clear Cell Contents with Google Apps Script
Автор: Spreadsheet Wise
Загружено: 2023-01-14
Просмотров: 8079
Описание:
Learn how to use Google Apps Script within Google Sheets to clear the contents of a cell when another cell is edited. This video relates to the Dependent Dropdown Chips, so if you haven't seen this, you can check it out here: • Dependent Drop-down Chips in Google Sheets
Google Apps Script used in this demo:
function onEdit(e) {
// Extract relevant data from the event object
var range = e.range;
var sheet = range.getSheet();
// Check if the edit is on the correct sheet and row
if (sheet.getName() === 'Sheet1' && range.getRow() === 2) {
if (range.getColumn() === 2) {
// Clear cells C2:D2 if column B (2) is edited
sheet.getRange('C2:D2').clearContent();
} else if (range.getColumn() === 3) {
// Clear cell D2 if column C (3) is edited
sheet.getRange('D2').clearContent();
}
}
}
For more videos and/or to subscribe, check out this link
/ @spreadsheetwise
Chapters
00:33 - Apps Script
02:36 - Script Permissions
03:30 - Run Script using the Sheet
03:52 - Final Script
Social Channels
/ spreadsheetw
/ spreadsheetwise
/ spreadsheetwise
https://www.pinterest.co.uk/Spreadshe...
#googleappsscript #appsscript #GoogleSheetsDropdownChips #Dropdown #dropdownmenu #dropdownlist #dependance #dependantdropdown #Spreadsheet #GoogleSheetsTipsAndTricks #GoogleSheetsHacks #googlesheets #googlesheetstutorial #Spreadsheetwise
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: