Tag Info

New answers tagged

1

The alternatives to IMPORTRANGE when passing ranges from one sheet in the same spreadsheet are QUERY, FILTER, an embedded array (i.e. ={Sheet1!A:E}) among others. Regarding the second part, check that your formula include all the required columns. I.E. If you use IMPORTRANGE("key","Sheet1!A:B") in Sheet2 it will bring only Sheet1!A:B to Sheet2. If you ...


1

Here's a script that you can tweak further for your use case. It adds a couple of custom new commands to the menu when the spreadsheet opens: The commands copy the content of the currently active sheet to the new one, named in the ISO date format, e.g., 2015-05-15. function onOpen() { var menu = [{name: "New Sheet as First", functionName: ...


0

Finally I have it working for different sheets in the same file: function onOpen() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var menuEntries = [] menuEntries.push({name: "Trace Dependents", functionName: "traceDependents"}); ss.addMenu("Detective", menuEntries); } function traceDependents(){ var dependentRefs = []; var ss = ...


0

Rather than a "Mail Merge" solution (one document for each record in a list), one alternative that could work for you use is something like UltraDox that include a feature to insert a spreadsheet into a Google document. I didn't tried it yet.


0

Instead of using a script, consider to add the responses to another sheet using formulas and there add the three columns. It's worth to say that Today() column will be updated when the recalculation occurs. I.E. Adding a column with the formula =Today() to the responses of a form add the following formula to A1 in a new sheet: =ArrayFormula( { ...


1

I don't think rowHeight can help you here, because it refers to the entire row, not to any particular cell in it. Sorting each column by RowHeight would just rearrange the rows without making your spreadsheet more compact. Here is the script that sorts each column by the length of cell content, ascending. The first row (headers) is left in place; empty ...


0

Google Docs doesn't have invisible placeholders at this time, but it has bookmarks. From the second reference: // Insert a bookmark at the cursor position and log its ID. var doc = DocumentApp.getActiveDocument(); var cursor = doc.getCursor(); var bookmark = doc.addBookmark(cursor); Logger.log(bookmark.getId()); References Using bookmarks in a ...


2

The following little script limits the cell input to 5 positions and adds the surplus as a note to the cell. Code function onEdit(e) { if(e.value.length > 5) { var c = e.source.getActiveCell(), v = e.value; c.setValue(v.substring(0,5) + "..."); c.setNote("Remaining text was: \n....." + v.substring(5)); } } Explained On each and every ...


2

Use a Data Validation with a custom formula. If the cell to limit the value length is A1 and the length limit is 5, then the custom formula is =LEN(A1)<=5 References Data Validation - Docs Editors Help


0

I wasn't quite sure what you meant by Range as an input to your custom function. Is this the source range or destination range? Anyways, this is something that should hopefully get you started. There is no timer element, nor is it a custom function. But can be converted to one easily. The manual timer element can be achieved by adding a trigger. In script ...



Top 50 recent answers are included