Questions tagged [google-sheets]
For questions about Google's web application to create and edit spreadsheets on a web browser or app. Don't use it for the Google Drive Excel files editor. Please consider adding a demo spreadsheet to your question; this will greatly increase the chance that you get a satisfactory answer.
7,578
questions
0
votes
0answers
2 views
Compare and remove duplicates in 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 ...
0
votes
0answers
4 views
Links to other google sheets
This may be question of understanding, rather than obtaining a solution. I have a google spreadsheet sheet embedded in a (public) word press website page. It contains columns with external hyperlinks ...
0
votes
1answer
8 views
Improve script performance
I wanted to ask, if I can do anymore improvements regarding my runtime, currently it takes roughly 100s to finish my script(since adding the formatting script below). Before adding additional ...
0
votes
0answers
6 views
Google Forms corresponding to a pre-set date on Sheets instead of being added consecutively
Is it possible to have Google Form data inputs being added not one after the other but corresponding with the Date that is pre-filled on the response form?
Here you can see how the data is currently ...
0
votes
1answer
12 views
"#NUM!" error in Google Sheets Script
When trying to Run the following script the result is always a #NUM! error - (Result is not a number) in cell "O5"
Both the cells are in currency format and I've tried changing them to ...
0
votes
1answer
20 views
Is there a way to add up the cost of multiple different items but not all the items in Googlesheets?
Im very new to this so please dont mind if its stupid
Im making a spreadsheet to manage your army in a game and I'm trying to add up the cost of different kind of divisions (Infantry, Sniper, Tanks, ...
1
vote
1answer
34 views
Google Script Substract Function
I want to create a script function that I will use with daily triggers:
function will subtract "Daily Fees" (a cell value that changes daily from "Open Trades" sheet) / from "...
0
votes
1answer
17 views
Calculate specific contents of a cell that contains a string of numbers and text
I have a sheet that contains cells that have lists of data within them, for example:
One cell contains: 1xExample, 2xAnotherExample, 5xThirdExample
The cell below contains: 1xAnotherExample, ...
0
votes
1answer
9 views
Convert Historical Currency in Multiple Rows with Preset Date and Amount
I downloaded some data from PayPal and they report certain transactions in the destination currency (PHP), but I need to get the currency I sent it in (USD), however, because these are historical ...
0
votes
0answers
14 views
Google Spreadsheets: Display static text on chart
I have a line chart that I've created in Google Sheets. This line chart is published to the web and embedded in another website as an iframe.
I have a cell in the underlying data that updates with a ...
0
votes
0answers
12 views
Help formatting data on sheets from google Forms
I am trying to format the sheet so that all the "items and quantities" list vertically for each time stamp. I have manually edited how i want it to look under the raw data
https://docs....
0
votes
1answer
29 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 ...
0
votes
0answers
9 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
1answer
13 views
Query function with variable in the Col1=
Here' the formula:
=query({{$P$3:$P$34;$R$3:$R$34;$T$3:$T$34;$V$3:$V$34;$X$3:$X$34;$Z$3:$Z$34;$AB$3:$AB$34;$AD$3:$AD$34},{$Q$3:$Q$34;$S$3:$S$34;$U$3:$U$34;$W$3:$W$34;$Y$3:$Y$34;$AA$3:$AA$34;$AC$3:$AC$...
0
votes
0answers
11 views
Google Sheets - SUMIF Contains
how are you doing?
I need to aggregate the total amount of money spent in campaigns that are divided in different sub campaigns. Just like this
Column A
Campaign - 1 - A
Campaign - 1 - B
Campaign - 1 -...
0
votes
0answers
14 views
Using a vlookup to pull from a table of a team min and max values for specific stats
So I am working on creating a stat sheet and learning a lot as I go along and using a lot of different tutorials and videos to learn how to write my own formulas, but I seem to be stuck on this one. ...
0
votes
1answer
10 views
Export Google Sheet
I have a Google Sheet that includes custom App Script. I need to:
Download a copy of the sheet.
Zip up the sheet.
Send it to another user.
Is there a way to do this in Google Sheets? For privacy ...
0
votes
0answers
8 views
Using Google Sheets to solve client scheduling problems
I am a small business owner who works by appointment with a fixed number of clientele. Clients come in at different recurring intervals (some once per week, every 2 weeks, every 3, etc) and for ...
0
votes
0answers
12 views
Google sheets, scale Axis to Date, not to item
So i have a simple line chart, it plots a value for each entry into the table it is made from.
Each only has 2 columns:
DateTime, and Value
The value is cumulative, so you expect and upward trending ...
0
votes
0answers
13 views
GSheets : How to find all GOOGLETRANSLATE formulas executed or not from external means? [closed]
I am developing a data processing app using Google Sheets and its API as backend .
In that I will upload all datas as arrays with GOOGLETRANSLATE via batchUpdate API like below
[hello_word,"Hello ...
0
votes
0answers
13 views
Google Sheets Pie Chart - Display Actual Value Below Label, not in pie chart?
I know I can get the actual value to show up in the pie chart, i.e. on the slice. However I want the percentage in the pie chart (which I can get to show up) since it is more likely to fit in a slice ...
0
votes
1answer
17 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 ...
0
votes
1answer
11 views
EXCEL Formula that calculates price after percentage discount, but needs to ignore a "-" to show no discount =IF(I40<>"-",(I39-(I39*I40)))
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
1answer
25 views
Google sheets sum cells if corresponding date is in range of a month
I have a sheet in google spreadsheets with every business day in one calender week and the working hours of the staff. Now I am supposed to create a sheet displaying the salary of the employees for ...
0
votes
0answers
44 views
How to list missing values in an unsorted list of value ranges in Google Sheets?
Here is an example of the data in cell A1:
1-3,8,18,9-12,12-15,5-7
What I would like to see in cell B1:
4,16,17
Any help in writing a formula or script would be much appreciated. Thanks!
0
votes
0answers
7 views
I am trying to figure out how to change a column of many dates so that any date that is "less than" 1/1/2021 will automatically change to 1/1/2021
I have the conditional formatting set to change the color of the cell. But I need the actual value to change to 1/1/2021. But only if it's less than. If it's more than that, then I don't want it to ...
0
votes
2answers
33 views
Google Sheets IMPORTXML Issue about Currencies
I've used these link and formula on Google Sheets to auto-update currency:
=IMPORTXML("https://tr.investing.com/currencies/gau-try";"//*[@id='last_last']")
However, it doesn't ...
0
votes
0answers
19 views
A formula to select a percentage of rows that make up a column
I am wanting to divide a column into 1/4ths and have totals calculated on just that fourth, but the amount of rows in that column will be changing. the forths will be simply based on order of ...
0
votes
0answers
7 views
Cell Range in Formula based on Computed Cell Name
I have a formula that finds a cell in a different sheet (of monthly net worth data), and a similar formula that finds the cell that corresponded to the same data 12 months ago.
Example:
=ADDRESS(MATCH(...
0
votes
0answers
14 views
Need helping knowing how to process this data in Google Sheets
I need to sort this data in Google Sheets. I have names and then each name has 4 letters assigned to it, one in each column.
An example is I need to know everyone who has a T and an I in column B and ...
0
votes
0answers
13 views
What's the best way to add helpful files or links to my Google Sheets document?
I want to keep my document clutter free if possible. But it would be nice to add an image link or a PDF link for myself and others to quickly have access to related information. I have tried to add an ...
0
votes
1answer
18 views
Sum Duration with google sheet
How can i sum duration with google sheet?
I need to sum this value
1:14:127
1:14:057
1:13:938
1:13:894
I set the cell with duration "mm,ss,SSS" and i try this formula
=sum(a1:a4) and
=TEXT(...
0
votes
0answers
17 views
Google Sheets - Loot Council. How to generate a list of items each character has priority on?
I've been manually making lists of all the items each character has priority on for easy comparison of who has how much.
The sheet has been updated and redoing the work is something I'm not happy ...
1
vote
1answer
23 views
What's the "if text contains" formula in Google Sheets?
To be specific, I want when I enter box C1 with a value like "done" both cell B and C will be colored green. For this I already did =$C1="done"
Tho this time I want it to change ...
0
votes
1answer
15 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 ...
0
votes
0answers
18 views
Using Google sheets to generate number based on two drop down list selections
So I'm trying to create a pricing calculator for my handmade business. I've gotten really far and have all my products separated out on different sheets based on material type, then have those sheets ...
0
votes
1answer
32 views
Google sheet pop up info
I use google sheets for woodcrafter members to log time to use our woodworking shop. The shop has a keycode entry and members are only to enter if they have booked time. All members were given access ...
0
votes
1answer
21 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 ...
0
votes
1answer
13 views
Type error: cannot read property getid of null in google script
When I run this script it show me this error. I can't understand what I do. Its function is to transfer results from html form to Google Sheet. Can anyone solve this problem?
var sheetName = 'Sheet1'
...
0
votes
0answers
9 views
IMPORTHTML not fetching the correct webpage [duplicate]
I made a spreadsheet, a part of which uses the IMPORTHTML function to get data from this webpage.
What I've written is: =IMPORTHTML("https://www.rbi.org.in/scripts/FS_PressRelease.aspx?fn=9?"...
0
votes
0answers
9 views
Import data from google sheet two into google sheet one if SHEET1CELLA1 equals a specific value
I would like to change the value in a certain cell, and have that import the complete data from another sheet that contains service information on specific unit# so that I can have multiple hidden ...
0
votes
1answer
23 views
#REF!, How to Grab the first response of form and ignore the duplicate in google sheets
I have a google form for attendance and I have a formula to automatically calculate the salary from the attendance. Sometimes people fill out the attendance twice with the same status (work/go home) ...
0
votes
1answer
27 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 ...
-1
votes
0answers
20 views
COUNTIF function not showing in google sheets?
I hope you are doing fine. I am trying to count a specific text from a column but when I type the count if it does not show up. Can someone help me with this, please?
0
votes
0answers
9 views
How to use hyperlinks in google spreadsheets to email threads for multiple users at the same time?
I'm running some data in Google spreadsheets and need to link a lot of different email threads to that spreadsheet. I need different users to have an access thru these hyperlinks directly to the email ...
0
votes
1answer
16 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 ...
1
vote
1answer
13 views
Activating cell after button click (remove focus from the button)
I have a sheet with one button (a shape) which is associated with an Apps Script function.
When I click the button it inserts a row and activates a cell in that row.
Then if I try typing, nothing ...
0
votes
0answers
9 views
Google Sheet search to return data from additional rows below
=transpose(FILTER({Log!S:S,Log!Y:Y,Log!Z:Z!AB:AB},Search(B37,Log!S:S))) returns adjacent cells in all rows it finds. How can I also get cells from the same columns n rows below from where search ...
0
votes
0answers
11 views
Google Sheets Merging two sheets together with common rows and uncommon rows
I have two Google sheets each with 4000 columns and 8 rows.
I would like to merge these two sheets together using 6 of the common columns and writing over 2 of the uncommon rows. Into a new sheet. Is ...
0
votes
1answer
18 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 ...
