coffeeandbooks

Renewal_GS

May 18th, 2021
623
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. // Candidate info = Row 2, Column 3  can be Y/N
  2. // Client info = Row 2, Column 7 can be Y/N/?
  3. // Values go to Row 2, Column 2
  4. // YT Video: https://youtu.be/vHZAQ-QBoPY
  5.  
  6.  
  7. function myFunction() {
  8.  
  9. var app = SpreadsheetApp;
  10. var activeSheet = app.getActiveSpreadsheet().getactiveSheet();
  11.  
  12. for (var = i=0; i<25;i++) {
  13.  
  14.   var candidate = activeSheet.getRange(2,3).getValue();
  15.   var client = activeSheet.getRange(2,7).getValue();
  16.  
  17.   if (candidate == "Y" && client == "Y"){
  18.     activeSheet.getRange(2,2).setVale("Renew");
  19.     } else {
  20.      
  21.     }
RAW Paste Data