GoogleSheet Group Category Reports Macros

gs-tiller-group-cat-report-macros.js

/** @OnlyCurrentDoc */

/** If you use Tiller & Category Rollup reports, this macro will create the groups to hide/collapse each level of report
 *  code from https://stackoverflow.com/questions/67784454/group-and-collapse-rows-in-google-apps-script
 * relevant docs:
 *  https://community.tillerhq.com/t/docs-category-rollup-report/121
 *  https://spreadsheet.dev/reading-from-writing-to-range-in-google-sheets-using-apps-script 
 * 
*/

function GroupSelectedColumn() {
  groupRowsInCatRollUpReport()
  return;
}
…      : sheet.getDataRange()
  ).getDisplayValues();
  let row = values.length - 1;
  while (row && !values[row].join('')) row--;
  return row + 1;
}