Questions tagged as 'google-sheets'

1
answer

Export Google Sheets data to the R

Everyone, okay? I'm new to R and I have a question: Is it possible, and if possible, what is the way to export data from a google sheets table (or Drive) to R. Is there any library for this?     
asked by 02.10.2018 / 19:54
1
answer

Clear Cell Content (A2) if the value of another cell (A1) is equal to a specific text

Please someone can help me with the following case: I have a worksheet in Google Sheets; I need a script to clean the contents of a given cell (A1) IF the text of another cell (A2) is equal to a specific text ("TABLE VALUE") Thank you i...
asked by 06.09.2018 / 17:13
1
answer

Send email if value meet criteria in column

I have a code that reads a "yes" value in a column and sends an email if that value is there. However, the if I created for this sends even if the value "yes" is not there. The code is below. My if seems to be correct. for (var i...
asked by 14.06.2018 / 06:47
0
answers

Open Google Drive document and apply filters

Hello, I started using Google Drive to make it easier to share documents between the various departments of the company, but I do not know how to create "Macros". I would like to have a MENU file where the various departments are located...
asked by 05.12.2018 / 16:59
0
answers

Send string to spreadsheet via email

Hello, I have a spreadsheet in GoogleDocs, which sends an email alert to the user via script when the deadline for a task is expiring. I would like the user, upon receiving this message, to have the option of clicking a button or link to stop re...
asked by 07.06.2018 / 21:42
0
answers

Values of a sheet not updating

I'm trying to send data to another spreadsheet. To do it, I wrote a code which I've been using for months, but I'm trying to use the same code with another spreadsheet and suddenly the code stops working. That is the sheet that I'm getting th...
asked by 25.11.2018 / 22:04
1
answer

IMPORTHTML on Google Sheets with error

I'm trying to create a file to grab Alexa's Audience Geography area / table data ( link ) but google sheets whenever I try to pull an error appears. =IMPORTHTML("https://www.alexa.com/siteinfo/twitter.com";"//*[@table='demographics_div_country...
asked by 05.11.2018 / 14:50
0
answers

Google Sheets Script

Good Morning! In the company I work recently we have changed the office package to the G-Suite and with this we are facing some problems because many sectors use excel for complex functions, then there is the problem: Today in Excel we have a sp...
asked by 20.09.2018 / 13:13
0
answers

Google Sheets - How to indicate a specific cell inside a query?

In the same document, I have one sheet with schedules per school and another with schedules per teacher. I want to change the sheet with the school schedules (choosing a teacher for a certain class on a given day), that the sheet with the teache...
asked by 14.09.2018 / 05:46
0
answers

Remove accent through formula in Google Sheets

I need to remove diacritics (accent and cedilla) in the values of a column in Google Sheets. I know that it is possible and easier to solve this problem through an App Script function, but this is a very common situation for me, and I am not alw...
asked by 16.08.2018 / 23:25