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.

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

How to show all formulas (Sum, Avg, count) in Google Sheets when you select multiple cells [closed]

Currently, when you select multiple cells, only 1 function is shown on the bottom right corner, either SUM or MIN or MAX or COUNT. How can I make it so that I quickly see all functions at once?
0
votes
1answer
8 views

Show and hide checkboxes in a column automatically when another column contains a value (or not) in Google Sheets [closed]

I need to automatically show checkboxes in column F but only when column G contains a value in the same row. Conversely, I want a checkbox to disappear or be disabled when the cell in column G in the ...
0
votes
1answer
11 views

How to change IFS function to switch in Google sheets? [duplicate]

I have this formula =ifs(OR(A1="January",$A$1="March",$A$1="May"),$A10,OR($A$1="April",$A$1="June"),$B11,OR($A$1="February"),$C10) I would ...
0
votes
0answers
8 views

How to change IFS function to switch? [closed]

I have this formula =ifs(OR(A1="January",$A$1="March",$A$1="May"),$A10,OR($A$1="April",$A$1="June"),$B11,OR($A$1="February"),$C10) I would ...
0
votes
0answers
5 views

Google sheets range of sheets?

I have multiple sheets in my Google Spreadsheet. Let's suppose that they are named "1", "2", ... "n". I would like to sum the contents of the B4 cells in all of these ...
-1
votes
1answer
11 views

Problems when sorting a Google sheet that someone else is editing

In the past, when two people were editing the same Google sheet, if person A attempted to do a sort they would get a "heads-up" warning that A's sort was going to affect person B. We now don'...
0
votes
0answers
11 views

Autofill Google Sheets formula incrementally

I'm looking to pull data from several separate sheets into one overview to have a snapshot picture of a range of booking in my venue. I'd like to look at the venue booking per space for any given day, ...
0
votes
0answers
11 views

Google sheets - edition inventory [closed]

I need help making a Google Sheets script to streamline our sales inventory. Right now we get a sale and it automatically updates a sheet, we then select that sale and manually copy it's info in ...
0
votes
0answers
13 views

Action paln formula for google sheet

I need to do a plan for my team. Name, time of working, and I need a formula that can assign randomly in the slot of 1 hour: chat, call, break, and task. I have to add a rule so that an agent per day ...
0
votes
1answer
8 views

Way to link to first (leftmost) tab in Google Sheet?

I have a Chrome bookmark pointing to a time tracking spreadsheet I have created. Every month I add a new tab for the new month, which becomes the first (leftmost) tab. Unfortunately this causes my ...
0
votes
0answers
7 views

Import data from Investing.com or other sites into spreadsheet not possible anymore? [duplicate]

I wanted to import from the section of historic data high/low prices in weekly ranges. For example from this site: https://www.investing.com/indices/us-30-historical-data I tried =INDEX(IMPORTHTML(&...
0
votes
1answer
18 views

Formula for Google Sheet

I need to do a plan for my team. Name, time of working, and I need a formula that can assign randomly in the slot of 1 hour: chat, call break, and task. It is a team of 15 people, I can't find any ...
0
votes
1answer
9 views

How to find closest similar value above current value, and return a different column on the same row

I'm looking for a way to find the closest similar value(in distance) above the current value(column B), and return the column next to that found value(column C) in column D. A sort of vlookup where it ...
0
votes
0answers
4 views

Show label when hovering over point in diagram

My chart is quite crowded but I need to be able to look up the manual labels assigned to each point. Is there a way to make Google spreadsheet show the manual label upon hovering over the point with ...
0
votes
1answer
17 views

Get the last three values of column in Google Sheets

I need to create a report that pulls the last 3 cell values in a column. This will need to be in three separate cells. Column C will contain data which will be added to daily. D2 will contain the ...
0
votes
0answers
16 views

How do you color a cell if no other cell references it? [duplicate]

I am making a spreadsheet with a bunch of variables I want to change and some formulas that use those variables. I want to use conditional formatting (probably?) to color any cells which are "...
0
votes
0answers
6 views

Differences between copy-pasting from Excel/Calc/Google Sheets to Whatsapp [closed]

When I copy an excel table (or libreoffice calc) and paste it on whatsapp web I have a photo but when I paste a Google Sheets table I get the plain text on whatsapp web, as well as the images below ...
0
votes
0answers
28 views

GogleSheet Date and Time Calculation - Automation

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. ...
0
votes
1answer
14 views

Depending on Sheet being edited, get a cell value and trigger OnEdit update

This code works but not as intended. The workbook has several tabs (Sheets) and if the user is editing Tab1, then and only then a trigger OnEdit should execute. If the user is editing some other tab (...
-1
votes
0answers
11 views

Create a formula in Sheet

I want to make a formula to check if the text of a column matches a text added in another in undefined range and without ordering and give as an answer yes or no. Example: In column A: Red wine White ...
0
votes
0answers
14 views

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
12 views

While using INDEX and REGEXEXTRACT, how can I return a blank cell instead of 0 [duplicate]

While using INDEX and REGEXEXTRACT, how can I change this formula to return a blank cell (instead of 0) when all of the cells in that section are blank?
-1
votes
1answer
16 views

Autofill Google Form for Sent Emails

Problem: I need to keep a comms log for emails sent by my teams to other teams. We are running a multiyear project that has over 150 customers. We often escalate and get responses from directors ...
0
votes
1answer
13 views

How to sort by merged cells in Google Sheet

I have been using this script for sorting and so I know it works. Now I'm trying to use it on a new Google Sheet project. Except that the column I want to sort the entire sheet by isn't just one ...
0
votes
0answers
11 views

While using INDEX and REGEXEXTRACT, how can I return blank cell instead of 0 [duplicate]

While using INDEX and REGEXEXTRACT, how can I change this formula to return a blank cell (instead of 0) when all of the cells in that section are blank?
0
votes
1answer
20 views

Google Sheets delete row based on table values

I have Google form feeding into a sheet. When a row is updated there is a Name column and ID column. If the ID column does not match the Name column for the specific row based on the table on a ...
3
votes
2answers
99 views

How to Apply Conditional Formatting Based on Adjacent Cell Value for Entire Column?

I am looking to apply conditional formatting to all cells in a column (excluding the header) where a colour will be applied depending on if its value is greater, equal, or less than the adjacent cell. ...
1
vote
1answer
12 views

How can I list column names with rows that only contain value

How can I list column names (in one cell) with rows that only contain value (blank not included)? If possible, separated by a line break.
0
votes
0answers
8 views

Protect identical ranges across multiple Sheets

I currently have a multitude of docs each containing 30-60+ sheets. Each sheet is formatted identically with the same headers/column labels. In doing research I found its not possible to mass protect ...
1
vote
1answer
29 views

GOOGLEFINANCE in Google Sheets to get high & low and timestamp of high/low from the day I took trade

I wanted to keep a track of high/low of a trade from the day I took the trade. For a day I am able to get high/low but how to get from the date I took my trade which is stored in one of cell. =IFERROR(...
-1
votes
0answers
17 views

Is there a script or add-on for Google Sheets that counts the number of used cells? [closed]

I am getting the error of reaching the 5 million cell limit in Google Sheets. I'm wondering if there's a script or add-on to count the used cells in the sheets/workbook. I found this add-on called ...
1
vote
1answer
18 views

Change Google Sheets displaying “0” for =Sum formulas

I'm putting together a spreadsheet in Google Sheets to keep track of my nutrition and weight loss. I want to make 2 charts, 1 that will display my weight over time and one that will display my calorie ...
0
votes
0answers
14 views

Add image in Google Doc from Google Sheet via Script

There is an image in Google Sheet (coming from Google Form) that I would like to insert in Google Doc in Image Format. Currently, I'm getting Url only from the below mention script. How can I get the ...
0
votes
1answer
9 views

Run Google Sheet Script Running for 1st entry only

I am currently running a google script to create a PDF from Google Form Inputs. I have moved my Form Response Sheet data to the 3rd row(image attached) (using the 2nd row for another formula). Every ...
0
votes
0answers
22 views

How Can I Get A List of Current Editors in A Google Doc/Slideshow/Spreadsheet? [closed]

I am a teacher interested in getting a list of students who are currently editing their assignments. (which are completed in Google Docs/Slides/Sheets) I am aware of the getViewers and getEditors ...
0
votes
1answer
14 views

Get the contents of a cell that is next to the maximum value in a certain range

I ran into a problem that I couldn't solve. Suppose we have a table: A B C D E F 20 SHOP PSU NAME POWER W/USD LINK PRICE 21 abc abc number number link number 22 abc abc number number link number ...
0
votes
1answer
19 views

Arrange Google Form Checkbox Responses into a List

I am collecting scholarship recipients in a Google form. The recipients names are in a checkbox format, as some donors give to multiple students. I need to separate out the names into additional rows, ...
0
votes
0answers
17 views

How to calculate probability in Google sheet based on previous years data

I was trying to get a leave taking trend and predict based on the trend that which dates are more likely to have higher number of leaves. I have a data set of date wise leaves taken by hundreds of ...
0
votes
0answers
7 views

Google finance condition to take 1 year return or from listing date

I am using following query to get 1 year price change percentage for a list of stocks,but some stocks were not available 1 year ago ,some got listed during the year. How can I modify the query to ...
0
votes
1answer
22 views

Is there a way to prevent spreadsheet from updating the date to today's date in formula? [duplicate]

I'm trying to print the date when I change the value on a cell (status column). But spreadsheets update the date to today's date. I wish it could save the date from when the status was changed. The ...
0
votes
0answers
8 views

Preventing auto population of information in Google Sheets calendar

I created a calendar in Google Sheets. I am using it to schedule appointments for several different clinicians. I was able to create a calendar with a drop down for each month of the year in which ...
0
votes
1answer
21 views

SPX 500 Monthly Return Google Finance

I need to formulate the SPX500 return from "x start date" to "x end date". I have managed to figure out "x start date" to current date (year to date return) but I cant ...
0
votes
0answers
11 views

add link as function input for google spread sheet function [closed]

I have found an online google sheet and I want to add more "automatic" inputs to it but I don't know how. The owner says it works with new URLs copied into the sheet but where should I copy ...
0
votes
2answers
25 views

How to correct this formula with If function?

I have a data filled from Column C9 to column I39 AND I Auto-Add text in Column J using this formula: =ArrayFormula(IF(I9:I39="Excellent","Excellent",IF(I9:I39="Good",&...
1
vote
0answers
12 views

How to add date criteria to query function? [duplicate]

I am using query function to copy all data from sheet1!A2:B10 to Sheet2 if B column is equal to specific data/time. Lets say A1 = 5 April 2021 A2:A10 names B2:B10 has Timestamp And I used this formula ...
0
votes
1answer
47 views

How to run a google sheets query against a dynamic range

Background I have a spreadsheet that displays data internet consumption by users that looks like this userid feb1 feb2 feb3 . feb29 u1 100 34 23 . 4 u2 ...
0
votes
1answer
11 views

Run a Google Sheets script on all tabs except one

Thanks in advance for the help. I am currently running a Google Sheets script which applies to one tab called "Tab 1". It copies a range across to the next free column as follows: function ...
0
votes
2answers
25 views

Why does google sheets query stop working on 6 decimals (but works on 5)?

I was creating a google sheets query that's pretty simple: query(<range>,"select Col2 where Col1 contains <number with decimals>") I noticed that it works when the number with ...
0
votes
1answer
11 views

How can I use a Drop Down List and skip data validation in Google Sheets?

I want to show a Drop Down List in a cell in Google Sheets, where user can choose a list of words. But I want to let to user to input any number too. Since the only way I know to show off a drop down ...
0
votes
0answers
15 views

Generate a line chart with each player's running score (competition tracker) [closed]

I asked this question on https://www.reddit.com/r/excel/comments/mikwvz/competition_tracker_create_publicly_accessible/?utm_source=share&utm_medium=web2x&context=3, but didn't get an ...

1
2 3 4 5
136