Get Visible Row ObjectsOps filter the sheet to “Status = Ready, Region = East” and click your menu item. They expect it to act on what they can see. getValues…
Get Selected Row ObjectsgetActiveRowAsObject is perfect for one row. Ops rarely stop at one. getSelectedRowObjects(sheet, headerRow) returns a header-keyed object…
Write Block Leaving Formula ColsappendRow and one wide setValues write every column — including the ones holding =VLOOKUP(…) or =IF(…). One run and your formula columns are…
