Questions tagged [google-spreadsheets]

Google Spreadsheets is a part of the Google Docs web app suite. Questions about Google Spreadsheets are off topic and should be asked on webapps.stackexchange.com, unless they specifically involve your computer or browser.

Filter by
Sorted by
Tagged with
0
votes
0answers
9 views

IF condition with ISBLANK using Google Sheets *driving me insane*

I have a Google Sheet for investment tracking setup and I'm trying to add a ISBLANK to the following formula: =IF(G67=TRUE,G12, G12*GOOGLEFINANCE(("CURRENCY:USDEUR"))) <--This formula ...
0
votes
0answers
15 views

Listing function points in a spreadsheet/excel [duplicate]

I am working on a Pre-Calculus Polar coordinate graphing project that incorporates some creativity; My current plan has me graphing the Nautilus Shell as my focal point. However, I have to list points ...
0
votes
0answers
15 views

How to get a vertical bar chart with the sum of rows grouped by month

I have a spreadsheet with over 300 rows, and in each row I have a Created At column with this date format: 20/Apr/21 5:34PM. I would like to have a vertical chart that is the sum of the rows for each ...
0
votes
0answers
17 views

Is it necessary to use ArrayFormula to get the SUMIF function to work properly in Google Sheets? [migrated]

I am trying to find the sum of values in a column based on the month in an adjacent column. For example, Sheet 1 has Three columns, one for student remark, one for payment date, and one for amount. ...
0
votes
2answers
33 views

Google Sheets / Excel - Create a minimum list based on multiple cells

I'm trying to get a minimum number (C) if A B and D combined match with any other row A B C D 1 iOS Safari 14.0 mobile 2 Android Samsung Internet 13.2 mobile 4 Macintosh Safari 14.0 desktop 5 ...
0
votes
0answers
10 views

How to force darkmode on google sheets? [closed]

I've tried various extensions that all support darkmdoe on chromium browsers but the actual cells and headers within google sheets seem impervious to all such mechanisms, resulting in everything else ...
0
votes
0answers
7 views

Simplify Google Sheets Sum Formula? [migrated]

This might be a super easy fix. I'm just getting started with formulas and I want to simplify my document so it can run a little faster. I have a big sum formula: IF(D2<>"X - Done";C2;...
1
vote
0answers
25 views

Optimizing sales in excel/google sheets

I have a table that looks like that: investment p1 p2 p3 1000 100 50 80 2000 200 60 95 3000 300 70 110 4000 400 80 125 5000 500 90 140 6000 600 100 155 7000 700 110 170 8000 800 120 185 ...
0
votes
1answer
14 views

Using IF to apply different rounding rules based on value range - error with too many IF arguments

I am trying to build a formula that will round a value in a cell based on these requirements round to 0 if less than 2% round to the nearest 2% increment up to and including 10% round to nearest 5% ...
0
votes
0answers
40 views

How to apply Text cell format permanently on a google sheet's column?

I recently added IDs as Number in a column those are basically built as alphanumeric. Then I've applied Text cell format on those IDs to keep their data consistent with the other cells in that column, ...
0
votes
0answers
11 views

Check duplicate then copy $ cell next to duplicate

I have a large dataset with duplicates in multiple columns the only exception is that for every duplicate the cell (email) is different. I want to copy that email and place in the same row as the ...
0
votes
1answer
25 views

How to copy rows of specific columns based on a criteria (and then continuously update)?

I have 2 sheets, let's call them sheet 1 and sheet 2. In sheet 1, I have some data where essentially at its core its a Scoring tally, something like this: Name Age Gender Score Jack 12 Male 155 ...
0
votes
0answers
6 views

how to remove contact from Google contacts when email removed from google sheet using apps script [migrated]

I have an Apps script when run: reads Google sheet, adds new contact/s ( name and email) into Google Contacts, a duplicate is prevented to be entered into Google contacts as well. However, I want when ...
1
vote
1answer
32 views

Get a drop-down list from another sheet based on lookup

I have a list of CA in my Source sheet that looks like this: And in my main sheet I need to get a dropdown list of "little a" for each CA, like this: Main sheet: Sheets: For example: ...
0
votes
0answers
6 views

GogleSheet Date and Time Calculation - Automation [migrated]

I have a column that has 34 records of Week Day, Month/Day, and Times. I am looking for two formulas that I can use in a table that will give me the count of weekdays and the time duration per day. ...
1
vote
1answer
35 views

How to calculate max sum held over a month?

I need help with a formula that needs to calculate the max sum held at one time for each month. In this example it would be 54 for March (12+13+14+15, held on the 29/03/2021). Month is determined by &...
0
votes
0answers
20 views

Cant make Alt + some keys shortcuts in Google Sheet behave like Excel on some computers

In Excel we have some Alt shortcuts like: Alt - E - S - V: paste special value only Alt - I - R: insert a new row In Google Sheets they can also be used. When I press Alt + I for example, I see this ...
1
vote
0answers
14 views

Specific format on multiple cells depending on the values of other cells

Let suppose I have A1:C3 for instance that I want to have a specific format (for instance blue borders) depending on another value of the spreadsheet, for MWE, A5:C8. A5:C8 could be binary values and ...
0
votes
0answers
27 views

Copying names from one sheet to another based on 1 of 6 criteria in another cell

I have a google sheets workbook with 3 tabs. 1st tab is the main tab I'm pulling from I have a column for names and a column of states the users are from. 2nd tab is for all users from the West and ...
1
vote
1answer
41 views

Sum and lookup over range in spreadsheet

I have a google spreadsheet that looks like this Items Item Value A 10 B 12 C 15 D 20 Calc Total Items A A B A A C C C In Total I want to have the a formula that sums the value of the ...
1
vote
1answer
28 views

Extracting text between two repeated sets of values in Excel

I have campaign names that conform to the following structure: [Network] - [Language] - [Country] - [Channel] - [Campaign Type] - [Free Text] This could look like: Google - English - India - Display -...
1
vote
0answers
33 views

How to edit Google Spreadsheets file directly in Google Chat window?

How can I edit sheets directly in chat window as shown in this commercial video?
0
votes
2answers
65 views

How do I sum the nth number from the right in all cells

I am using a spreadsheet to collect all my questions and answers for a quiz I am doing. In the answers column, every answer is ended with [#p], # representing the numbers 1–9, never exceeding 9. ...
0
votes
0answers
16 views

How to reference “This” Column?

Maybe I'm dumb, but how do you just reference "This" or "Current" column? For example, counting entries in a column. I know you can enter a formula & drag it, or copy it & ...
1
vote
0answers
14 views

How to show different type of legend below specific columns under X axis on stacked bar chart

I have drawn a stacked column chart in Google sheet. I want to put different legends below specific columns as secondary label under the x-axis; here is my spradesheet link: https://docs.google.com/...
0
votes
0answers
11 views

How to return the sheet name of a given cell of a query result

I have scrubbed the internet for answer to this and and either I am asking the question the wrong way or it isn't possible. Here is a example template of what I am wondering about: https://docs.google....
0
votes
1answer
44 views

Merge two seperate columns in Google Sheets into a single column [duplicate]

I have a list that contains people's names in one column and their company's names in a second column. At the top of each column there is a label, i.e "Name" for column A, "Company"...
0
votes
1answer
68 views

How can you show the first cell in a cluster in Excel? And how can you lookup the value?

Several questions. But let me break down the problem of what I am trying to do: I have a condition to show YES/NO if a certain value is met. If YES >= 60 and NO <=30 - this is easy I can do ...
0
votes
0answers
28 views

Excel sheet to read data in real time from *shared* spreadsheet

I have an online quiz setup using Google Sheets, and I want to transfer it to Excel. Here's what I have: Team1,...,Team9 have their own 'Answer Sheets' which are Sheets with a cell, A2, where they ...
0
votes
0answers
28 views

Convert automatic values into raw data in Spreadsheets

I receive data automatically from a website into a Google Spreadsheet. So each new entry gets a new row. Within that spreadsheet I added a new tab to re-layout the data "nicely". I do that ...
0
votes
0answers
10 views

Google Sheet “View only” - add my own comments (for my own viewing only)?

I have access to a Google Sheet that's "View only" (so I can't edit or comment). I was wondering though if I could nonetheless add my own comments and other annotations for myself? (So for ...
1
vote
2answers
58 views

Is it possible to reuse the same sumif range?

In the following table, I constantly reevaluate a2:a4 to run different calculations against it. In a real table it would have been thousands of rows like it. Is there a way to somehow store a2:a4 in a ...
0
votes
0answers
19 views

How to average different % values depending on drop down list text value

I am trying to have a function that takes the %'s of a column and average them only if the text value of another column on the same row is a certain text value, over multiple rows in sheets I tried ...
0
votes
1answer
31 views

How to highlight down columns for many columns at once that are separated in an excel sheet?

I have 30 columns of data with over 10,000 rows. I'm using Ctrl+Click to highlight specific cells and then use Ctrl+Shift+Down arrow to highlight to the bottom, but I noticed it won't let me do that ...
0
votes
0answers
27 views

Original Google Sheet recognized by JS. Copy not recognized

I have a working Google Sheet JSON search engine here: https://codepen.io/Teeke/pen/gOwgvXQ?editors=0011 It reads this Google sheet: https://docs.google.com/spreadsheets/d/1c2aJmDdLkbjW0ErfUB0sfiQ-...
0
votes
3answers
53 views

Sum of vlookups for each value in a row

There should be a way to do this, and yet I'm struggling... ==The Data== Sheet1 A B +---------------+-------+ | Fishy_Product | Price | +---------------+-------+ | Cod | $9....
1
vote
1answer
51 views

Microsoft Excel/Google Sheets - Update Adherence

I would like to produce a result wherein it checks if an update is done within 3 hours, it would be pass. If it goes beyond 3 hours, then it would be a fail. So this is how my raw data looks like: ...
0
votes
1answer
52 views

Too Many Arguments when using IF google sheet

I want to implement this formula in Google sheet and I'm getting the error for too many ifs. Any help? =IF(I2="win",SUM(J2*G2),IF(I2="loss",SUM(J2*-1),IF(I2="push",J2),IF(...
0
votes
1answer
25 views

Can I make a graph for iterative function in MS Excel or Google Spreadsheets?

Let's say I have a formula: k = 0.2 a = pow(a, k) I'd like to see how the curve changes on each iteration with a different k value. The formula can be anything. The only thing is - I need the ...
1
vote
0answers
14 views

How to prevent duplicate URLs in google sheet? [closed]

Is it possible to prevent duplicate URLs in google sheet like the following: User enters URL: https://superuser.com/questions/ in a row of column C. If user wants to enter any subdomain or other URLs ...
0
votes
1answer
527 views

google sheet formula, if “yes”, copy to other sheet

I’m trying to figure out the formula in google sheets - if the cell is “yes”, then copy the adjacent cell to another sheet. Can anyone help?
0
votes
1answer
87 views

What is the processed called when converting data in repeated columns to rows on a spreadsheet?

If I have a spreadsheet with a data structure where similar information is repeated across multiple columns like so: TxID Date Merchant Item 1 Name Item 1 Value Item 2 Name Item 2 ...
0
votes
2answers
73 views

Return text string for highest duplicate values

I've been battling with a google sheets conundrum so hoping someone can help. In a nutshell, I'm trying to achieve the following based on the image below: Where the name is the same in column C ...
1
vote
0answers
19 views

In Excel/Google Sheets, how can I get the rows between two strings/headings which are in the first column?

I have a sheet which is formatted like this: original_sheet Header1 Row 1 Row 2 Row 3 Row 4 Header2 Row 6 Row 7 Row 8 Header3 Row Row Row I am looking to copy the rows under each header into their ...
0
votes
1answer
134 views

Excel/Sheets - Adding the content of a row to the end of another?

So I'm still new-ish to data analysis on Excel and/or Sheets, and I'm trying to "merge" data. Essentially, I have a few thousands rows, and I want every second row to be added to the first. ...
0
votes
2answers
60 views

How do i search and replace the entire cell content by a string in excel?

I have some cases to replace the following string with another string TES1 if the string has _M1 in it. Where ever _M1 is there I have to replace the whole cell content with TES1. similarly, I need to ...
0
votes
0answers
43 views

Fill down every (x) rows for (x) rows inserting as new rows instead of overwriting what's below in spreadsheet (WPS Office)

I have an existing CSV which contains shipping rates for every country in the world. I need to extend the rates for each country. Each country currently occupies 80 rows each. Every 80th row (the last ...
0
votes
0answers
24 views

Link to a tab in an Online Excel spreadsheet

Can you link to a tab in an Online Excel spreadsheet like you can with Google Sheets? Both Microsoft's and Google's online spreadsheets have tabs (like all spreadsheets). With Google Sheets, if you ...
0
votes
2answers
285 views

Sql Group By with Max equivalent in Excel

My excel sheet has this data as an example: type |make |price -------------------- cars |honda |500 cars |acura |600 cars |ford |550 trucks |toyota |350 trucks |ford |475 trucks |...
0
votes
1answer
19 views

Trying to count a particular character in an excel sheet and the formula needs to change with each row

enter image description here Is there any way to change the formula based on the cell the formula is in, for example. If the formula is in the 5th row. I'd like it to count the occurances of the ...

1
2 3 4 5
8