Guest User

Untitled

a guest
Jan 13th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. function hideRows()
  2. {
  3. var dataI = sheet.getRange('I2:I').getValues();
  4. var dataN = sheet.getRange('N2:N').getValues();
  5. var count = getLastPopulatedRow();
  6. var array = new Array(count);
  7. var arrayCount = 0;
  8. var startingRow = 0;
  9.  
  10. for (var i=startingRow; i<count; i++)
  11. {
  12. if ((dataI[i][0] == "Completed") || (dataI[i][0] == "Duplicate") || (dataI[i][0] == "Refunded") || (dataI[i][0] == "Was Already Fulfilled") || (dataI[i][0] == "Cancelled")) {
  13. array[arrayCount] = i+2;
  14. arrayCount++;
  15. }
  16. }
  17.  
  18. for (var i = 0; i < arrayCount; i++)
  19. {
  20. sheet.hideRows(array[i]);
  21. }
  22. }
Add Comment
Please, Sign In to add comment