This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/***What should this script do? | |
1. Loop through all of the spreadsheets | |
2. If the row after the row that contains AssociatedCampaignName is blank, Write "Waiting For Spot" in the next row after the cell that contains AssociatedCampaignName, IE: A2 | |
3. Write "#" in B2:H2 | |
**/ | |
function waiting(){ | |
var ss = SpreadsheetApp.getActive(); | |
for(var n in ss.getSheets()){// loop over all tabs in the spreadsheet |