Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function hideRows()
- {
- var dataI = sheet.getRange('I2:I').getValues();
- var dataN = sheet.getRange('N2:N').getValues();
- var count = getLastPopulatedRow();
- var array = new Array(count);
- var arrayCount = 0;
- var startingRow = 0;
- for (var i=startingRow; i<count; i++)
- {
- if ((dataI[i][0] == "Completed") || (dataI[i][0] == "Duplicate") || (dataI[i][0] == "Refunded") || (dataI[i][0] == "Was Already Fulfilled") || (dataI[i][0] == "Cancelled")) {
- array[arrayCount] = i+2;
- arrayCount++;
- }
- }
- for (var i = 0; i < arrayCount; i++)
- {
- sheet.hideRows(array[i]);
- }
- }
Add Comment
Please, Sign In to add comment