COPY PASTE SCRIPT IS NOT SHOWING CORRECT RESULT HI, i have a file in which i generate weekly report. E3:BJ3 in sheet "production summary 2" is the m…

0 Updates 0 Recommended Answers 5 Replies 0 Upvotes

Remove just one space How to remove one space in any group of spaces? i.e. Convert "r e m o v e o n e s p a c e i n a n y …

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Looking for Help to Combines 2 Queries into 1 Query Hi everyone, I have 2 Queries : =QUERY({Report!E2:M},"Select Col1,Col2 where Col3 CONTAINS 'IN' and …

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

How to add a "name" after a formula Hi, I'm trying to make a simple spreadsheet but I don't find a way to add a "name" behind my formula…

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

check if-function against a list Hi, can someone please help me with the if-function to check against a list insted against a single …

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

Google sheet - AddTimestamp I try to have "Date" in a cell when i use a checkbox but i don't understand. I need your help. TypeE…

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes

Import data with Query if it matches what is in a column I can't get my head around how to do an importrange query if the data matches what is in 2 columns. …

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

Need help with script to send out email when empty cell is filled Hi All! I have a script that sends out an email when an empty cell is filled. But the issue is that …

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

GQuery: Attempting to evaluate and return the Min of a set of dates in a Group In the linked sheet, in Cell D14 I'm trying to evaluate the minimum date from the two groups in H3:H…

0 Updates 3 Recommended Answers 13 Replies 4 Upvotes

Why does Importhtml only return 12 rows? When i type =IMPORTHTML("https://prosettings.net/cs-go-pro-settings-gear-list/";"table";1) it only r…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

i want to click on a button to mark "1" and if il click another times "11" i want to click on a button to mark "1" and if il click another times "11" {function macrosun() { va…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Pie chart not accurate Google sheets As you can see in the photo, the pie chart is not accurate https://docs.google.com/spreadsheets/d/1k…

0 Updates 0 Recommended Answers 4 Replies 0 Upvotes

Help with multiple IF and THEN formula Hello, I am having a little trouble developing a formula in which is somewhat doing my head in and b…

0 Updates 1 Recommended Answer 11 Replies 0 Upvotes

Retrieving cell value based on a named column and named row. I'm trying to figure out how to retrieve a cell value based on the value of the skill name and the c…

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes

How to pick out numbers attached to specific categories Hi there! So in creating a budget sheet I set up data validation so I can categorize all my expenses…

0 Updates 0 Recommended Answers 6 Replies 0 Upvotes

How to generate random combinations in sheets? Ok so for a personal project, part of it involves genomes. I need to take two genomes and randomly g…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Complex array question In August of last year I had help from the community to clean up image urls in google sheets, screen…

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

How to automatically create new tab from a list and link it? I'm trying to find a way to automatically create a new tab based off a template when a new name is a…

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes

Counting Attendance sheet I have an attendance sheet that records the attandace of students for several days with 5 periods in…

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

COUNTIF, IMPORTRANGE Google Sheets I want to count the number of occurrences an email address appears in another Google Doc that I have…

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes