Freelancer:
deepakrawat3993
Gsheets script for pack size
Hello CH, I'm interested in this project and i think i can do it. Do you need google spread sheet formula or google app script for doing that ?
Public Clarification Board
-
deepakrawat3993
- 4 years ago
sample code in picture :
function createHeaders() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
sheet.setFrozenRows(1);
var values = [
["Size", "Demand", "pack1", "pack2", "pack3", "pack4","pack5","supply","diff"]
];
var range = sheet.getRange("A1:F1");
range.setValues(values);
}- 4 years ago
