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
1answer
10 views

Send email when cell value equals 29 [duplicate]

I am having trouble with my google sheets script and I wondered if anyone had any advice for a beginner. I want my script to check a cell value (Sheet1, H2), then send an email if the value = 29. ...
0
votes
1answer
12 views

Automatic Invoice Number

Need some help with making my invoice number automatically go up by 1 once I have hit the button to save the invoice in Google Spreadsheets thanks
0
votes
2answers
13 views

Function/formula to return only the first string proceeding the first carriage return

Is there a function/formula to return only the first string proceeding the first carriage return using Google Sheets? Example Text: Bob & Mary Smith bob@email.com 555-111-1234 Assuming ...
0
votes
2answers
21 views

Searching Multiple Columns From Single Source Sheet in Google Sheets

I have a Sheet where I have all of my data entered. I have been able to filter the information to other sheets no issues when only searching in one column. I am having issues when trying to search 2 ...
-1
votes
0answers
8 views

Can i import external map data to regularly update output in cells?

I am attempting to use ~real-time Google Maps routing data times to update various drive-times in a Sheet. I realize that each individual route in Maps has a unique link, so this should help. (I ...
0
votes
1answer
10 views

How can I use a filter to show everything except cells containing specific words?

I'm importing a Google Calendar (ics link in A2 that I'm importing with an IMPORTDATA function) and it has system dates related to 1970 that I obviously want to filter. How can I specify to show me ...
0
votes
2answers
24 views

How to stop banding from re-appearing on Google Sheet

I'm using banding to highlight some areas, with a section in between with a fixed colour. It should look like this. Sometimes, when I enter a number in the blue area in the middle, the banding ...
-1
votes
0answers
9 views

“Publish to the web” not working with ImportJSON when original file is closed

I'm unable to reliably share a sheet from Google Sheets with "Publish to the web" reliably, since it displays zeros as values instead of the values I have in the original sheet. I have a ...
0
votes
1answer
10 views

I need to extract a data validated cell content and use it as a part of a new formula

I would like to give the user the option to choose between DAYS360() and NETWORKDAYS(). For that, I thought about adding these 2 to a data validation cell. Afterwards, I would like to be able to add ...
0
votes
1answer
10 views

How to use multiple criteria with Regexreplace in Google sheet?

I am trying to correct the number/expression of room numbers that are entered by users with the following: 1- If the number contains ( / or \ or _ ), it will be replaced with "-". 2- If the ...
0
votes
0answers
9 views

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

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 ...
0
votes
0answers
12 views

How to use Divide function actively? Ex: If I change the value of divider, how do I keep this up to date?

How do I make the values of divided, sum etc. active? I can't figure this out. If I use the =DIVIDE(etc). the values in these cells stay the same if I change the values of divided or divider.
0
votes
0answers
15 views

Google Sheet: calculation/math inaccuracy [duplicate]

I found weird math error. I was doing calculation that comes down to this: =TRUNC(253-0.81*300) This comes back as 9, but should be 10. For some reason, when you increase the visible decimal places, ...
0
votes
1answer
24 views

Plotting gigantic values + smaller values on the same Google Sheets chart?

I'm trying to plot a chart that includes one data set in billions, another in millions, and a third in thousands. What is the most efficient/elegant way to do this using google sheets without the ...
0
votes
1answer
9 views

typing 1 to 9 on keyboard does not trigger editing cell in Google spreadsheet

When on a iPad in Google Sheets and typing 1,2,3,4,5,6,7,8 or 9 does not trigger the editing of a cell. 0 and all other characters do. Is this a new feature/bug in google sheets or can I change a ...
0
votes
0answers
7 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
24 views

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

I need to automatically add 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
18 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
14 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
8 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
15 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
8 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
19 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
19 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
20 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
36 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
12 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
15 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
14 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
9 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
32 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
16 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
24 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 ...

1
2 3 4 5
137