Tag Info

Hot answers tagged

3

Please try something like: =vlookup(A1,Sheet2!H:I,2,0) where ColumnH in Sheet2 ('other sheet') contains Number and ColumnI of the same row the corresponding unit price.


2

https://developers.google.com/admin-sdk/email-audit/ The Google Apps Email Audit API allows Google Apps administrators to audit a user's email, email drafts, and archived chats. In addition, a domain administrator can retrieve account login information and download a user's mailbox.


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

Yes, it's possible, select the mask (not the image), grab the little dot on a stalk and drag it round half a circle:


1

You can use this IFTTT recipe to automatically copy new events from one calendar to another.


1

Go into your domain administrator account, and delete his user (if it's there). Also set the option to not forward all otherwise-undelivered emails to your administrator account. After you do this, all messages to his account will bounce.


1

I'm not sure exactly how you're pulling in the Master Sheet info to the Client Sheet, but to help with some background, when your zap adds a new row to a spreadsheet, it's literally creating a new row and filling that new row with data. This can impact how that data can be automatically retrieved depending on the details of the formulas, scripts, etc you're ...



Only top voted, non community-wiki answers of a minimum length are eligible