Google Sheet - Dropdown List function time processing too slow on large data. Hi all, I created a google sheet form where each user can input their data and send it back to me. W…

0 Recommended Answers 1 Relevant Answer 3 Replies 0 Upvotes

Using AVERAGEIF/AVERAGEIFS Across Sheets Hello, I am running into trouble trying to average certain cells across multiple sheets. A simplifie…

0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

GAS - Send one email contains multiple rows of data I have a data similar to this sample spreadsheet https://docs.google.com/spreadsheets/d/1q2CZA8cr1Tf…

0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

Set global font I had document and used default font arial, then I ctrl+a and switched all to verdana, yet when I cl…

0 Recommended Answers 3 Replies 0 Upvotes

Presentation sharing bug When I share an Untitled presentation to my friend, the email he receives is: [Bad Word:] Presentati…

0 Recommended Answers 1 Reply 0 Upvotes

In the Google Docs mobile app, my I (italics) button has completely disappeared? I woke up this morning and suddenly the only options are B for Bold and U for underline. There is no…

3 Recommended Answers 24 Replies 11 Upvotes

Why doesn't Sheets change to new month when dates are updated I have a pivot table that changes monthly. I change the dates in the dataset to make them current. T…

0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

Copy and paste script that does not paste all the values Hello, I have a script to copy and paste values ​​but it does not copy the value from a formula: ​fu…

0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

Are personal templates now going to be available? Google has said that all the Workspace features are going to be made available to users with free pe…

0 Recommended Answers 1 Relevant Answer 2 Replies 2 Upvotes

What's "fx" in Sheets formula bar? On the left of the formula bar there is the Name box. On the right of the formula bar there is the F…

0 Recommended Answers 1 Relevant Answer 4 Replies 0 Upvotes

Dates not pulling right into email script, any help? I have a script that is running on a sheet to auto email me whenever a date is 2 months out, 6 month…

0 Recommended Answers 1 Reply 0 Upvotes

Creat a call center interactive script Hello, I am currently looking at taking on new staff to answer my phones and want to create a intera…

1 Recommended Answer 1 Reply 0 Upvotes

"Error creating a new document" Hi, I'm in trouble. I cannot create new documents, a message appears saying "Error creating new docu…

0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

How to create a unique ID for a row of data from a trigger I want to create a unique ID in SubmitData() and save it along other data in the form on my Data She…

2 Recommended Answers 11 Replies 0 Upvotes

Looking for help with Vlookup that pulling unwanted data Hi everyone, i was looking to one question in the community and I notice I do look for the same as a…

1 Recommended Answer 20 Replies 1 Upvote

Custom header images won't work I'm having trouble with google forums, it seems that when ever I try to put any image for the header…

0 Recommended Answers 12 Replies 6 Upvotes

getting the value from a scrip at a particularly time of the day. eg, price of apple at say 11 am When using google finance functions in google sheets, how can we get value of the price at a particu…

0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

Break up Forms response spreadsheet into sections I'm probably in over my head here, but I've got a form that has section 1 asking for some basic info…

1 Recommended Answer 3 Replies 0 Upvotes

Insert Special Character - Search by description of character missing Hi Google experts! I usually utilize letters like A, a, n, S, s, etc with markers like "acute above"…

0 Recommended Answers 7 Replies 2 Upvotes

Is there a way to change default cut/paste and dragging behavior? I use Sheets for scheduling my work day appointments, and appointments are constantly getting moved …

0 Recommended Answers 0 Replies 0 Upvotes