getQueueNumber.js

// get queue number
function getQueueNum() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var range = sheet.getRange(1,getColByName('status'),sheet.getLastRow());
  var values = range.getValues();
  
  var queue = 1;
  
  var statuses = ['Pending','pending','In Progress','in progress','In progress','in Progress'];
  
  for (var row in values) {
    for (var col in values[row]) {
      if (statuses.includes(values[row][col])) {
        queue++;
      }
    }
  }
  
  Logger.log(queue.toFixed());
  return queue.toFixed();
}