chipoglesby

/***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