Most voted "google-sheets" questions
Google Sheets is a spreadsheet program included as part of the free web-based Google Docs Editors package offered by Google. With it it is possible to perform advanced mathematical and statistical functions in a structured and automated way. Note that non-programming issues are within the scope of the Stack Overflow, for example those involving the basic use of the tool.
Learn more…43 questions
Sort by count of
-
7
votes1
answer204
viewsExport data from Google Sheets to R
Hey, guys, what’s up? I’m a beginner in R and I have a question: It is possible, and if possible, which is the way to export data from a table of google Sheets (or Drive) to R. There is some library…
-
2
votes2
answers72
viewsClear 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 spreadsheet in Google Sheets; I need a script to clear the contents of a given cell (A1) IF the text of another cell (A2) is equal to a…
-
2
votes1
answer29
viewsCompare two columns in excel and create the third
I need to compare the Column A item with all items in column B, if this item is not present in column B, it is generated in column C. What formula do I need to use to do this?…
-
2
votes2
answers933
viewsPick up only the final stretch after the regular expression bar
I did a general search here and on Google and I came to find something that worked partially. I have the following text pattern: 030.000.208 OUTRA COISA 001.005.001 ALGUMA / COISA AQUI COM - TAMBÉM…
-
1
votes0
answers33
viewsSend string to spreadsheet via email
Hello, I have a spreadsheet in Googledocs, which sends, via script, an email alert to the user when the deadline for a task is expiring. I would like the user, when receiving this message, to have…
-
1
votes1
answer22
viewsSend email if value meet a criterion in the 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 that I created for this sends even if the value "yes" is not there. The code is below.…
-
1
votes1
answer6307
viewsRemove accent via formula in Google Sheets
I need to remove diacritical signals (accentuation 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…
-
1
votes2
answers561
viewsIMPORTHTML in Google Sheets with error
I’m trying to create a file to get the data from Alexa’s Audience Geography area/table (https://www.alexa.com/siteinfo/twitter.com) but google Sheets whenever I try to pull appears an error.…
-
1
votes0
answers85
viewsOpen Google Drive document and apply filters
Hello, I started using Google Drive to make it easier to share documents between different departments of the company but I don’t know how to create "Macros". I wish I had a file MENU where the…
-
1
votes1
answer79
viewsForm is blank after pressing a button, help me!
I’m kind of new at programming in HTML, CSS and scripts in general. I understand almost the basics of the operation and I am trying to organize the receipt of documents in my Department, had done…
-
1
votes0
answers99
viewsRecord date of change of two cells in one
The following code detects whether a change has been made to a cell in column I or J, and records the date and time the change occurred in column M and N. I want there to be only one record, that…
-
1
votes1
answer360
viewsDate calculation: today’s date, new date() and date extracted from Googlespreadsheets
I’m trying to subtract two dates. Today’s date, using the new Date(), and a date from a googledocs(photo) spreadsheet. Column F that stores the dates of googledocs is in the dd/mm/yyyy date format.…
-
1
votes0
answers50
viewsHow to deploy form as web application ? [Google Script]
Good morning Gentlemen I am with huge doubt how to publish this form as web application ,this as reference to active spreadsheet and on the web will need to reference the spreadsheet vi url I do not…
-
1
votes1
answer59
viewssetValue() in several vélulas (.foreach ???)
I use the function below to concatenate the value of the current cell in google Sheets and a link to create a function HIPERLINK() in the same cell. function setCustomLink(){ var ss =…
-
1
votes2
answers89
viewsHow to call a function within itself? Recursiveness
Goal Make a recursion within the function SALVARHISTO() so that the function is called again, if the cell A8 is not found. What I tried to I tried to put a condition at the end, if the A8 cell was…
-
1
votes0
answers20
viewsGoogle App Script in Google Calc - Cell using imported function does not update its value
I have several google sheets (Google Calc) using a script made in Google App Script as library. The problem is that cells using these imported functions do not update their values when the imported…
google-sheetsasked 3 years, 7 months ago Laércio Araújo 11 -
1
votes0
answers17
viewshow to make a summation range dynamic to include only the days of a given week
I have a table (google Sheets) that generates dynamically, by choosing the month, a calendar sheet formatted with different colors for weekends and holidays. I intend to add the weekly hours on the…
-
0
votes2
answers167
viewsHow to filter so that accents are not differentiated in Google Sheets?
Hello, I have a column with names of cities, that the names are placed in different ways: "São Paulo", "SAO PAULO", "Sao Paulo", "São Paulo", etc. I need to filter this column, even with a script,…
-
0
votes1
answer38
viewsHow do I copy information from a column in googlePlanillas without repeating data if they have repeated data?
i have a spreadsheet in which a column contains names, I need to copy this data to another column, but without copying the repetitions of the names, example: Coluna A Coluna C Américo Américo…
-
0
votes0
answers36
viewsCriteria for sending email - google-appscript subtraction module
The goal of the following code snippet is to take a date that is in column 5 subtract it from today’s date and, if the module of this division is equal to zero, an email is sent. In case, I want an…
-
0
votes1
answer1245
viewsHow to create a CSV file via Python by keeping the decimal separator in the same place?
I have a Python script that makes a request via API and saves the data in a CSV file. The data is stored in different lists in Python and should be saved in different columns in the CSV file. The…
-
0
votes1
answer66
viewsHow to create a function that creates a new page in google Sheets
How do I do a function that I can perform in the spreadsheet that generates a page with the given name? Because in the example below I am getting the error: Exception: You do not have permission to…
-
0
votes0
answers21
viewsI would like to add the contents of a cell to the Scrip message
I created a script that when a certain date arrives it sends a merge, only in this message I would like to add the contents of a cell of the spreadsheet where the script is running this function…
-
0
votes1
answer936
viewsHow to run multiple onEdit functions in the same script (google Sheets)?
I tried several ways and none worked. I want a function that when someone types something, the cell content automatically becomes all uppercase and no accents. E.g.: if I type "aaaauu", it…
-
0
votes1
answer54
viewsgetNextDataRange() from google Spreadsheatapp bug?
Hello I came across the following situation: I just need to use a class method Selection from Google Spreadsheetapp in an enabled selection, but it is bringing the following bug: ReferenceError:…
-
0
votes0
answers1194
viewsInsert automatic date - GOOGLE DOCS
I am trying to automate a part of the spreadsheet, where the date after change is inserted. The function is like this: function onEdit(event) { var Timezone = "GMT-3"; var timestamp_format =…
-
0
votes0
answers32
viewsIteration Googleappscript
I made the following code to iterate and take the value of two columns, B and E. If "B" contains the value SIM and "E" is empty, it adds "1" to the counter, and returns the sum at the end. However,…
-
0
votes1
answer9533
viewsProblem with promisse, returns: "Promise {<pending>} "
Talk personal! I have a problem connecting Node.js with Spreedsheet. I use the function below to fetch the 'date' value in my spreadsheet. Until then it works very well, however, when I use "date"…
-
0
votes1
answer58
viewsData from a file. Json
Eai guys, all right? ... I’m having a problem where I need to get a data block from a json file, being it: { "custom_fields": { "[TS] A empresa em que você trabalha é": "uma fábrica/indústria",…
-
0
votes1
answer261
viewsI’m getting this error message >>> Typeerror: Cannot read Property 'pop' of null (line 5, "Code" file)
I’m trying in Google Sheets to sum the values of cells that have the same color background. The problem is that the code is returning me the following message: " Typeerror: Cannot read Property…
-
0
votes1
answer74
viewsPython - How to get the date of the last Google Spreasheets update?
Personal talk! Next, I needed to check if there were any updates to the Google Spreasheets shared document. I thought I’d bring this field: as a date or as a timestamp in python and check with the…
-
0
votes1
answer18
viewsI cannot change cell format with . setNumberFormat in google app script
I made the following registration page. I need to pick up exactly the amount of zeroes I add to the registration field However, when this data is added to the spreadsheet, only a zero appears. I am…
-
0
votes0
answers11
viewsGoogle Sheets - Error "Cell Reference out of range" coming by email
I just started writing my macros on google Sheets, so it may be that my codes have some very glaring errors and some redundant lines, but let’s go Basically, I have an integration in integromat that…
-
-1
votes1
answer60
viewsCount specific character amount in a range
I have a data range similar to that: I need to count how many V’s and D’s are in between. I’ve tried using SUMIF and COUNTIF Can someone help me?…
-
-1
votes1
answer369
viewsThe value of Function INDIRECT parameter 1 is "Income! D3:Q3". It is not a valid cell/range reference
I’m using the spreadsheet templates provided by google. However I’m getting this message: The value of Function INDIRECT parameter 1 is "Income! D3:Q3". It is not a valid cell/range reference.…
-
-1
votes1
answer402
viewsCreate script where if a column is not empty type " message " in another column
If column 6 is not Empty, the script stamps "make loans" in column 13. I tried to accomplish something like script below, because it could be done by a formula, but it cannot have formulas in this…
google-sheetsasked 5 years ago thiago Ferreira 11 -
-1
votes1
answer94
viewsButton does not send form and/or run javascript
Come on, guys. So... I’m having trouble making the button that would send a completed form to a spreadsheet in Google Sheets and then reset the fields, the entire application is running on the site…
-
-1
votes1
answer28
viewsSet value to another spreadsheet
Good morning, I created a script that takes the " Cancel " value from a column and where you have " Cancel " the script erases this line, but I need it to copy this line and send it to another…
-
-1
votes1
answer247
viewsConvert Macro excel to Google Sheets script
I would like a help to transform this macro code from excel to the Google Sheets script. I don’t know the resources so much, I’ve cracked my head moving but it didn’t work. Basically he removes the…
google-sheetsasked 4 years ago Thiago 3 -
-1
votes0
answers21
viewsUse setValue in a custom formula in Google Sheets
I am creating a system that is integrated to Google Sheets, one of the spreadsheets I use has two pages, the Sending and the Code that is composed of the columns code and status, need that through a…
-
-1
votes0
answers4
viewsHow to modify a value after it has been moved to another column or row in Google Sheets?
I need to create a Script for my Google table The main idea is that when I move the value of a cell up or down this value is edited accordingly Ex: If moved to a row above increment or if moved down…
-
-1
votes0
answers8
viewsFind information from my HMTL via Javascript in Google Script. error(Document is not defined)
Good afternoon guys. It’s my first post, but I always come here to seek knowledge. today I’m having a problem that the copilator of google script does not see a command to trigger a Function. When…
-
-3
votes0
answers19
viewsUpdating a Gsheet with Gspread and pandas
I am getting a bit to use python and am trying to update a google sheet through gspread and reading a CSV that is on my pc with pandas. my code stayed: import gspread from…