Browse the Google Docs Editors Community
Create email via button in Sheets, have the message auto-created & displayed in Gmail, but not sent I'm moving a spreadsheet over from Excel to Sheets and my email from Outlook to Gmail. The Excel ver… 0 Recommended Answers 1 Reply 0 Upvotes DGET fails to produce proper results when two lookup entries are similar I am running into a weird DGET error in Google Sheets.
in one table, I have the following entries:
C… 1 Recommended Answer 10 Replies 0 Upvotes How to do to use for a formula using 3 functions arrayformula, si , or ? Hi, I want to concat the first name and last name for a full name if Type = "P" or Type ="B" in the … 0 Recommended Answers 1 Reply 0 Upvotes Creating a Pie Chart using non-contiguous, vertical data. Greetings, I think this is possible, but can't figure out how. I have some data that's scattered abo… 0 Recommended Answers 1 Reply 1 Upvote combine all values in one column based on another Hello! I have two columns in which one — column A — describes a type (let's call it animal) and anot… 1 Recommended Answer 11 Replies 0 Upvotes locate last cell and include in formula =(J22-J5)/J5 But what if I wanted to find J22 how would I have included that in the formula. Been se… 0 Recommended Answers 4 Replies 0 Upvotes How do I apply conditional formatting correctly? I am working with Ben Collins Advanced Formulas Day 10. I am trying to emulate the formatting he app… 0 Recommended Answers 4 Replies 1 Upvote Some Queries based on Cell work... others.... do not...Should I use Filter, or Sort?
Hey I am back...Last time I got great advice and help, so here I am again. Thank you in advance I am… 0 Recommended Answers 0 Replies 0 Upvotes Sheet files I own opening in VIEW I'm using a Samsung Galaxy S9 phone. I create files using Google Sheets and I'm the Owner of each fi… 0 Recommended Answers 0 Replies 0 Upvotes Automatically Increase a cell value Hi everyone. This is what I am trying to achieve: Value in cell A1 is 0001 I want the value in cell … 1 Recommended Answer 5 Replies 0 Upvotes allowing only one box to be checked in google sheets I would like to allow only one checkbox to be checked in each set of my spreadsheet. I believe the o… 0 Recommended Answers 4 Replies 1 Upvote Remove contents in [XXXX] using TRIM + SUBSTITUTE Hi I have a 'roster' for a game and the RAW data that comes from a Database includes information I d… 0 Recommended Answers 1 Reply 0 Upvotes Workaround on a sheets issue Please click this link for my original question, complete with a link to a Google Sheet example: htt… 0 Recommended Answers 2 Replies 0 Upvotes Update all new players Gill, After looking closer at the march update, the Update sheet data isn't there, and the trade val… 0 Recommended Answers 1 Reply 0 Upvotes Requesting from Lance.NYC. Pick up dates from specific column. Hi Lance, a couple months back, you had helped me figure this one out. We had the Summary table F co… 1 Recommended Answer 4 Replies 1 Upvote Creating a chart based on a number in a cell I'm trying to create a spreadsheet for employee performance reviews. I already have it set up to tel… 0 Recommended Answers 0 Replies 0 Upvotes Run Queries and Functions without Opening Sheet I have a sheet that imports data from another sheet. On the sheet with the imported data I break out… 0 Recommended Answers 1 Reply 0 Upvotes Notifications Not Working on Sheets Notifications for changes made to my sheets stopped working as of 2/26. I checked File > See Version… 0 Recommended Answers 0 Replies 0 Upvotes Sheets email notification not working Dear Community, I can't set Sheets to send the email notifications whenever the content of the Sheet… 0 Recommended Answers 4 Replies 0 Upvotes Add an image to Google Sheets add-on Not sure whether this is the right place to ask this question. Feel free to delete if it is not the … 0 Recommended Answers 1 Reply 0 Upvotes