Tag Info

New answers tagged

1

This should give a good idea how to fill multiple dropdowns from one data array where each column sets the dropdown value. function onSuccess(values) { //values is a 2d array. var opt, dropDown; for(i = 0;i < values.length; i++){ dropDown_one = document.getElementById("id_one"); if (values[i][0]) { //check if there actually ...


3

Add a new select with a new id, and assign a set of values the same way. This should give a good idea how to fill multiple drop-downs from one data array where each column sets the drop-down value. function onSuccess(values) { //values is a 2d array. var opt, dropDown; for(i = 0;i < values.length; i++){ dropDown_one = ...


2

Below is a rough example of how to show / hide individual columns from a Google Sheet. function onOpen() { var ui = SpreadsheetApp.getUi(); ui.createMenu('Custom Menu') .addItem('Show View A', 'showViewA') .addItem('Show View B', 'showViewB') .addItem('Show All', 'showAll') .addToUi(); } function showViewA() { var sheet = ...


2

Firstly, you'd have to remove the ` from the end of first line, that may have caused some errors. Secondly, here's the sheet and code (also to be found below). Since detecting whether a column/row is hidden or not has not yet been implemented, I have made a little workaround for you. When hiding given column(s), it adds "(hidden)" to their header and that ...


3

There's a defect listed on the Google Apps Script issue tracker. We'll have to wait it out to see when a project member responds to it, I'm assuming.


0

Overview There are two main situations: How to replicate the number of rows inserted How to set the corresponding formula to each cell 1. How to replicate the number of rows inserted One alternative among others is to use the Change Google Sheets installable event instead of OnEdit. The Change event has the property changeType. Your project could use ...


1

Whenever an argument is a range containing more than one cell, the custom function receives a 2D array. For example, suppose this is your spreadsheet. +---+---+---+ | | A | B | +---+---+---+ | 1 | 5 | 7 | | 2 | 6 | 8 | +---+---+---+ Then: myFunc(A1:B2) receives [[5,7],[6,8]] myFunc(A1:B1) receives [[5,7]] myFunc(A1:A2) receives [[5],[6]] - ...


3

See if this helps ? =ArrayFormula(query({A1:C,C1:C}, "select Col1, Col2, Col3, count(Col4) where Col1 <> ''group by Col1, Col2, Col3 label count(Col4)''"))


0

This is super and has saved me much work - thanks. However the answer above does not find any references that use the row- or column-fixer $. The following slight change to code accomplishes that: function onOpen() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var menuEntries = [] menuEntries.push({name: "Trace Dependents", functionName: ...



Top 50 recent answers are included