Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
2answers
16 views

How to increase Chrome performance while working on resource-heavy Google Sheets?

I'm working on a spreadsheet which is full of data and formulas, and I wondered if there is anything I can do to increase the performance of Chrome besides switching to Excel? My device has 2.8 GHz ...
0
votes
0answers
4 views

Google Sheets Conditional Formatting Formula [migrated]

I am doing a formula in conditional formating and I need it to be relative to each of the 1500 rows but it keeps retrieving an absolute value. how do I get around putting a new formatting formula for ...
0
votes
0answers
3 views

How to go to the first blank cell directly in a colume of Google Sheets? [migrated]

I use column A mainly; A1 is the name of data type, and A2, A3, A4, ... are data. When I open this file, It shows the screen containing the first cell, A1. If I fill data from A2 to A250, then I ...
0
votes
0answers
4 views

Concatenate - Show blank cell result if a cell is empty [migrated]

Could someone help me... I am trying to create a social media keyphrase strategy using keywords. I would like to know if Google Sheets could return a blank cell if one of the cells in the concatenate ...
0
votes
0answers
11 views

Creating Tabs in Google Docs [migrated]

I know in google sheets you can compile multiple spreadsheets by using the tab feature at the bottom. I was wondering if there is any way to do this with google docs. Thanks.
0
votes
0answers
12 views

SUMIFs across multiple sheets, only looking at the first sheet listed

I've been working on this for a few hours, but for the life of me I can't quite figure out why its behaving this way. I'm using the following formula: =SUMPRODUCT(SUMIF(INDIRECT(Sheets&"!D:D"),...
0
votes
0answers
7 views

How can I merge drop-down columns in Google Spreadsheets? [migrated]

Please see Investment Portfolio Tracker - TMOAP Official Version 5.2. If the three columns (in red rectangles) remain the same for rows 5-20, it's obviously foolish and unproductive to click on the ...
0
votes
0answers
18 views

How can I use a table/chart to view the cells that fall within a specific date range?

I have sales data that shows the start (min) and end (max) sell date of a product as well as a count of the products being sold during a given month. I need to filter to see which products are being ...
0
votes
0answers
18 views

How to repeat rows and add increment numbers at the end?

I need a formula to duplicate specific rows (the rows contain name data) a number of times and add incrementing numbers in the end. It should look something like this: problem I found a way to ...
0
votes
0answers
19 views

conditional formatting for a full column based on the average value in that row?

I'm going through a sheet with multiple different data points across different rows (for different versions of the same action each on their own row). In order to easily compare from one row to the ...
0
votes
1answer
72 views

How can I count the number of cells that fall within a date range?

I'm trying to look at hundreds of products being sold over the last few years to compare sales performance. i.e. did Product A sell more quickly than Product X or were there just fewer products to ...
1
vote
1answer
69 views

When a Google Sheet is exported to Excel the line heights of wrapped text are not maintained - any way to change this?

Ive got an issue when exporting an Excel file form a Google Drive Sheet. If i have a large amount of text / data in a cell in Google Sheets i use the wrap text feature so that all the text is ...
0
votes
0answers
14 views

Google Sheets: insert literal text that begins with = [migrated]

I would like to add text that begins with equal sign in a cell but I get the following error: #NAME? Question: How can I set a cell's text to a string that begins with the = sign ?
0
votes
0answers
9 views

How do I copy multiple tabs in a sheets workbook to a “master” sheet?

Does anyone know how to code a proper app script function/macro whenever turned on it would transfer data from multiple google sheets into one master sheet, all in the same workbook. I tired functions ...
0
votes
0answers
12 views

Time not formatting as expected in Google Sheets [migrated]

I imported a report to Google sheets and the duration column shows 7 h 37 m or 14 h 5 m a similar format. When I replace h with : it still does not properly format to time duration and so I cannot ...

15 30 50 per page