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