All Questions
34,068
questions
0
votes
1
answer
53
views
Error on multiple myfunction in onEdit
I am getting an error ReferenceError: options is not defined at myfunctionFDI(OverallScript.gs:39:48)at onEdit(OverallScript.gs:3:1), when I am trying to run multiple myfunctions within onEdit, what ...
0
votes
1
answer
364
views
How do I get importrange and jointext to combine 3 name cells into 1 cell on a new worksheet in Google sheets?
On Wksht A I have cells C5=last name (i.e. Doe), D5=first name (i.e. Jane), E5=first name (i.e. John). This is to cover 2 joint owners (i.e. husband and wife) in our housing complex. I want to import ...
- 11
0
votes
1
answer
276
views
Google Sheets' IMPORTDATA randomly converts number
We have a simple REST endpoint that returns a number as a string. The number is rounded to two decimals and has a point, like this: 2385.1
Google Sheets then sometimes transforms this into 177418 or ...
- 103
0
votes
1
answer
402
views
Compare and remove duplicates in Arrays (Google sheets)
I have two arrays of many rows , in my Google sheets, which have numbers such as
Active
Recovered
904;1505;1706
406;504;1502;1503
202;401;602;1104;1501
202;1502;1602;1704
I have shown only two ...
- 199
0
votes
1
answer
97
views
Sum all numbers prepended to text that matches a search string
I have cells that contain multiple strings delimited by commas.
Each string is comprised of the following 3 elements joined together:
A number
An x
A substring
For example, 1xExample, 2xExample, ...
- 1
0
votes
1
answer
917
views
Using IMPORTXML in Google Sheets: How to Combine XML Data Sources as a Single Set Before Applying XPATH Query
Using the IMPORTXML function on Google Sheets, I've got two XML data sets at two URLs, respectively in cells A1 and A2. I've got the XPATH query in cell H1. I would like to run a single query on the ...
- 227
0
votes
1
answer
27
views
Reorganize csv data
I work in a school that has multiple data entry forms and formats and I am trying to find a way to automate one example of data duplication.
We put student report card grades in on one online system, ...
0
votes
1
answer
264
views
GoogleSheet's Output of IMPORTXML Function Changes Format of Imported ISO Date-Time Text
I have a GoogleSheet that's been working fine using the IMPORTXML function, until recently.
It seems that when the function imports XML data that are in ISO date and time format that it changes the ...
- 227
0
votes
1
answer
41
views
Formula that calculates price after percentage discount, but needs to ignore a "-" to show no discount =IF(I40<>"-",(I39-(I39*I40))) [closed]
So I have a formula for adding subtotal after a percentage discount is taken off.
(I39-(I39*I40)
I also have a dropdown list for percentages so 10% 15% 20% and none labeled as -
This is what I have =...
0
votes
1
answer
139
views
How do I delete my FreeSO account?
Last year I made a FreeSO (https://freeso.org) account to play with a friend, but now I don't want to keep it around any more. However, I can't seem to figure out how to actually delete my account. ...
- 243
0
votes
1
answer
44
views
Summing groups, Aggregate costs by items in groups
I have a sheet with a grouping by Feature / Subfeature / Task.
Here is an example:
How can I aggregate the cost from individual tasks to subfeatures (eg. rows 147-150 of Sign-In subfeature group) and ...
- 101
0
votes
1
answer
51
views
Google Sheets Formula Not Working in Excel
I have this formula pasted below that works in Google Sheets, but not in Excel. I've looked up possible solutions, but just cannot find what may be the problem with it. The return I get is just the ...
- 11
0
votes
1
answer
516
views
Avoid keeping adding numbers in headings in Google Docs
I am using a modified version taken from this useful answer to get numbers in my Google Docs Header 2:
function myFunction() {
var pars = DocumentApp.getActiveDocument().getParagraphs();
var ...
- 103
0
votes
1
answer
841
views
How to use importxml to pull just one of several lists
This site has answers to a game called Spelling Bee which is published daily. I want to use importxml to pull the answers (which is a list of words) into Google Sheets, but I am a novice on this ...
- 137
0
votes
1
answer
780
views
How to sum cells that are in hexadecimal format
First of all, read 32, 1023 with the 0x32 and 0x1023 to identify that it is a hexadecimal number.
When we only have numbers the sum is done with decimals and it seems to work. The problem is that in ...
0
votes
1
answer
131
views
Auto add a row based off a check box
I'm a new user to Sheets! I'm reaching out for help on a problem that I have with trying to create row. I've read a ton of blogs, and watched more Youtube videos than I care to admit without finding a ...
- 1
0
votes
2
answers
46
views
Google Sheet Formula Error
Hoping to get a little help with a formula I am making I have used it in other columns to calculate an outcome, but for some reason when I go to decimals under 0 it give me a #N/A "No Match"....
0
votes
1
answer
77
views
Possibility of Saving Hidden Value in a Repeat Group as A Case Property in CommCare?
Is it possible to save a hidden value as a case property, especially if the hidden value is a repeated value? I have attached a screenshot of what the derivation of the field that I want to save as a ...
0
votes
1
answer
33
views
How do I have one column be the sum of two other column automatically and infintitely
I have two columns A and B, and a third column C. I want row N in column C to automatically sum and values in row N of column A and B.
I want to summing to occur from the second row onwards, ...
- 133
0
votes
1
answer
1k
views
Creating leaderboard in Google Sheets
Example: https://docs.google.com/spreadsheets/d/1vE5DSC5bQMuHGMk3IRtLqFpTlr6AsfFvk0hMYZLts7o/edit?usp=sharing
Let's say I have the following table
Table 1 is titled "Scoring"
Tom
Mike
Carl
...
- 103
0
votes
1
answer
47
views
How many days to interest compound goal
I usually use this google sheets formula to calculate the compound interest, for 30 days.
B2*((1+B3/100)^30)
B2=invested amount
B3=daily percentage
I would like to have a formula to calculate how many ...
- 1
0
votes
1
answer
25
views
Sending an email from a column on Google Sheets when I enter X in the last column
I am a high school teacher looking to streamline my late work process. I have a google form the students fill out telling me their name, hour, email, and what assignment was late. I added a column ...
- 9
0
votes
1
answer
198
views
How to view all emails in inbox for my gmail
When a "spam" email comes, I would rather just delete it than let it sit in my spam. What I would prefer is that regardless of whether I am on my phone, computer, etc. when any email comes, ...
- 103
0
votes
1
answer
558
views
In Google Sheets, can you repeatedly autofill until next non-blank cell or until a value in another column changes, whichever comes sooner?
I'm trying to format a CSV file that contains a huge list of products (8000+) that are on separate rows but need all the fields to be on the same row. The trouble is that some of the cells are ...
0
votes
1
answer
448
views
How do I allow users to insert youtube videos in google slides
I am an administator of a google education account. Recently teachers have been unable to insert youtube videos by URL in Google Slides. They are getting the message "You can't insert YouTube ...
- 11
0
votes
2
answers
2k
views
How to copy text in a table cell in Notion?
When I select a table cell and copy it, all I have is a list of links. I want to copy text only. Is this possible?
- 854
0
votes
1
answer
361
views
Google Sheets "Query" issue with rounding
I am using a formula of:
=INDEX(QUERY($I$19:$I$30,"select I where I >= " & rounddown(D$27,2) & " order by I limit 1",0),1)
In D27 I have a value of: 0.8190
In I19:I30 I ...
- 111
0
votes
1
answer
390
views
How to emulate behavior or cmd + down arrow in Google Sheets Macros?
If there is a column of 10 full cells in a row, and you go to the top of the column and hit command + down arrow, it activates the lowest non-empty cell.
I tried to record a macro while using cmd + ...
- 1
0
votes
1
answer
125
views
Can I request a revision to a recommendation letter after I’ve accepted it?
I’ve accepted a recommendation letter on LinkedIn. Can I still request that my recommender revise the letter?
- 11
0
votes
1
answer
86
views
How do you utilize conditional formatting for times over multiple days in Google Sheets
I am trying to visually see when events are taking place on our site. I have a list of events, their start date/time and end date/time. I would like to create a visual such as a Gantt chart that shows ...
- 1
0
votes
1
answer
196
views
ImportHTML Script at Bulk
With great help, this script is working to pull in the 2nd table on the below link. The table cannot be scraped with IMPORTHTML unlike the first table (Regular Season works, Playoffs doesn't).
https:/...
- 120
0
votes
2
answers
195
views
How to show a report that has "numbers in thousands" as full numbers?
If I have a lot of numbers in thousands and I don't want to use regexp to append to them three zeros to see the real number how can I proceed? I didn't found yet a formatting solution or any other ...
- 103
0
votes
2
answers
136
views
How to stop date reformatting of SPLIT() output?
I have content like "3 4 5; 5 6 7; 8 9 10" in a cell and I would like to split it by the semicolons so that I have "3 4 5", "5 6 7", and "8 9 10" in three cells....
- 101
0
votes
1
answer
136
views
I can't unlock a swimlane in draw.io
I have an existing swim lane diagram with flows and connectors. I want to move the 3 rightmost lanes over to the right but the 4th rightmost lane keeps hiding behind the lanes I move. It seems locked -...
0
votes
1
answer
314
views
Clear cells script
So I have a google sheet document which houses figured for each hour of the day from 6 - 16:00 (each hour in a different tab.
I’m looking to add a script and a button that will allow me to clear all ...
- 11
0
votes
1
answer
44
views
How to identify specific data in a column
I'm doing my first App Scripts and I'm able to have them working... but I remain dependant on some Sheets formulas to identify data. This impacts the speed of my script dramatically.
As a basic ...
- 35
0
votes
1
answer
27
views
Google Sheets: Number Formating
I am trying to use this number format: 0.0,,"M"
Which will display the number 1,234,567 as 1.2M, however, once the number becomes 1,250,000, the value rounds up.
Is there a way to make it to ...
- 1
0
votes
1
answer
87
views
How do I retrieve historical currency exchanges rates (USDEUR) in Google Sheets?
I am not quite sure how to get historical exchange rates from Google Sheets. It is the start date and number of days, daily/weekly that is confusing to me. I was able to get the current exchange rate, ...
- 880
0
votes
1
answer
357
views
Flip a column of Data vertically Import range
I'm importing the data from another sheet using the import range. How can I flip a column of data vertically in another Google Spreadsheet?
=sort(index(IMPORTRANGE("URL")
E.g. if the column ...
- 1
0
votes
1
answer
2k
views
Google Sheets query formula: using a cell reference as a string
I'm trying to write a query formula in google sheets using where/contains to find values in another sheet that correspond with the text in column A of the original sheet. Since there will be hundreds ...
0
votes
1
answer
334
views
Where it goes the paper size information in a script
I'm using this scrip to save to pdf but I need to make it Size A5 and Landscape Orientated
I have found some parameters but I don't know how to combine
function checkSheet() {
var sheetName = "OS&...
0
votes
1
answer
683
views
Count a consecutive streak of values in Google Sheets, if the values aren't all the same?
So, I have a Google Sheet with various readership/writing stats, and I'm using one column to log how many words I'm writing every day. I'd like to use that column to calculate writing streaks, i.e., ...
0
votes
1
answer
888
views
Google Sheets - Arrayformula with textjoin, and, if
I'm trying to figure out how to make my arrayformula with textjoin to work, but the formula does not copy to another row.
I want the job no automatically generate when i write data in F3 cell & ...
- 3
0
votes
2
answers
34
views
Sum Column of Unique Rows from two Ranges
Hopefully I explain this well.
I have a sheet with 2 tabs, Data and Report. I am trying to make a formula on the Report tab that sums up total paid by new Clients.
Essentially: Look at Data!A:I, find ...
0
votes
1
answer
25
views
Set up formula to accumulate hours from selected benefit
I am trying to set up my google sheet to automatically adjust hours in the top section in the column "Used" when I input data into the details section. for example:
In details section, when ...
- 5
0
votes
1
answer
166
views
Calculating overtime pay in google sheets
I'm not very savvy with Google Sheets/Excel so I have been fumbling my way though attempting this. I'm trying to calculate amount of overtime pay for a given time worked. For instance: From hours 0-...
- 1
0
votes
1
answer
252
views
Conditional formatting across documents
I run several youtube channels and have an upload schedule for each.
I also have a master schedule that shows uploads across all channels. Each of these are different sheets within separate documents ...
- 1
0
votes
1
answer
64
views
how to use regextract to find occurences of a number when it ends with a 2 after decimel point
my number set looks like this example
-360.132,
125,
140.0152,
-400.13,
i would like to be able to have an if statement for the numbers that end with a "2" after the decimel point. So i want ...
- 99
0
votes
1
answer
272
views
Why does my closed LinkedIn account still show up on Google searches?
I thought I closed my LinkedIn account...so why is it still showing up on Google searches?
- 1
0
votes
1
answer
31
views
Google Sheets - searching combinations of cells for value maxes
I'm trying to do some organizing for my characters in a video game I play. I'm not sure if/how I can do what I'm trying to do. Essentially, I'd like the "Max Crew Skills" cell range in the ...
- 101