Tag Info

New answers tagged

0

I had a similar problem. sheetSpider does not appear to be available anymore. I tried writing my own script and it kinda worked but it was slow and didn't update reliably when the source data changed. I eventually solved my problem with a pivot table (Data->Pivot table report...). Just select the range, then add all the columns you want to see as Rows ...


0

IFTTT looks like it can meet your needs. Specifically, this recipe: Add receipts & orders to Receipt Spreadsheet. (There are also other similar recipes.) This recipe is triggered by a new email message with particular words in the subject, and adds a row to a specific spreadsheet. You'd just need to customize it to your specifications.


2

You can add a Google Script inside the spreadsheet that looks something like this: function save() { var ss = SpreadsheetApp.getActiveSheet(); var threads = GmailApp.search("subject:X"); for (var t in threads) ss.appendRow([threads[t].getFirstMessageSubject()]); }


1

Create a sort key, for example by combining actual values and your custom list orders, such as with lookup tables and concatenation, eg: =VLOOKUP(C2,H:I,2,0)&"|"&D2&"|"&VLOOKUP(A2,F:G,2,0)&"|"&B2 then sort on that column.


0

This is the official web site for Google Apps Script: https://developers.google.com/apps-script/ Nowadays, it has an extensive help and tutorial section:


0

Use the following code to change the date notation. Code var curDate = Utilities.formatDate(new Date(), "GMT+1", "mm/dd/yyyy") References formatDate(date, timeZone, format) date notaions


1

Use the following code. Code function onOpen() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var shs = ss.getSheets(), num = shs.length; var sheetnames = []; for(var i=0; i<num; i++) { sheetnames.push(shs[i].getSheetName()); } return ss.toast(sheetnames, "Greetings!", 300); } Explained The sheets are zero based (as arrays are). ...



Top 50 recent answers are included