sheetsmarts

// Developed by SheetSmarts
// For tutorial, go to https://youtu.be/WJ79TNhX3ls
// To verify that the below code is safe : Copy code and paste into ChatGPT and ask it to check if the code is safe to use.

function hideColumnsInFiles() {
 var spreadsheetIds = ["spreadsheetid1","spreadsheetid2","spreadsheetid3","spreadsheetid4","spreadsheetid5"]; // specify the spreadsheet IDs of the workbooks
 var columnsToHide = [2, 3]; // specify the columns to hide


 for (var i = 0; i < spreadsheetIds.length; i++) {

sheetsmarts

// Developed by SheetSmarts
// For tutorial, go to https://youtu.be/h-8P2PmYA3k
// To verify that the below code is safe : Copy code and paste into ChatGPT and ask it to check if the code is safe to use

function generateOutputAndCreateNamedRangesWithoutSheet() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getActiveSheet();


  // Prompt the user to enter the column letters for class names and student names/values

sheetsmarts

// Developed by SheetSmarts
// For tutorial, go to https://youtu.be/HyNP4OvrgoE
// To verify that the below code is safe : Copy code and paste into ChatGPT and ask it to check if the code is safe to use.

function createButtonsInSlides() {
  var presentationId = "Your presentation id"; // Replace with your presentation ID
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Sheet1");
  var slide = SlidesApp.openById(presentationId).getSlides()[0]; // Assumes the button should be placed on the first slide of the presentation

sheetsmarts

// Developed by SheetSmarts
// For tutorial, go to https://youtu.be/o6nCgxouQ38
// To verify that the below code is safe : Copy code and paste into ChatGPT and ask it to check if the code is safe to use.


function setFontAndResize() {
  var fileIds = ["fileId1", "fileId2", "fileId3"]; // Replace with the file IDs of your  files
  for (var i = 0; i < fileIds.length; i++) {
    var file = SpreadsheetApp.openById(fileIds[i]);
    var sheets = file.getSheets();

sheetsmarts

// Developed by SheetSmarts
// For tutorial, go to https://youtu.be/osX0L4mHQ3A
// To verify that the below code is safe : Copy code and paste into ChatGPT and ask it to check if the code is safe to use.

function createSheetsFromCategoriesWithRows() {
  // Get the active sheet and data range
  var sheet = SpreadsheetApp.getActiveSheet();
  var dataRange = sheet.getDataRange();
  var data = dataRange.getValues();

sheetsmarts

// Developed by SheetSmarts
// For tutorial, go to https://youtu.be/1HoTd4P8wko
// To verify that the below code is safe : Copy code and paste into ChatGPT and ask it to check if the code is safe to use.

function unmergeFill() {
  // Get all sheets in the active spreadsheet
  var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
  
  // Loop through each sheet
  for (var s = 0; s < sheets.length; s++) {

sheetsmarts

// Developed by SheetSmarts
// For tutorial, go to https://youtu.be/oA3nyYIB7V0
// To verify that the below code is safe : Copy code and paste into ChatGPT and ask it to check if the code is safe to use.

function duplicatefolder() {
  // Prompt the user to enter the name of the source folder and store the value in a variable called "sourceFolderName"
  var sourceFolderName = Browser.inputBox("Enter the name of the source folder:");
  // Prompt the user to enter the name of the target folder and store the value in a variable called "targetFolderName"
  var targetFolderName = Browser.inputBox("Enter the name of the target folder:");