Karl_S
  • Member for 7 years, 2 months
  • Last seen more than a month ago
  • Mid-Atlantic - USA
Changing my Gmail address
5 votes

You could Block that sender if you wished. Unless they are creating multiple accounts. If you really want to create a new one, you can create a new account and forward the old one for a short term ...

View answer
Concatenate ordered values in one single string
4 votes

Use the JOIN() function: =join(" - ",sort(Sheet1!B:B, 1, TRUE)) SORT() returns an array of values. JOIN() concatenates an array with a joining string, in this case " - " without the quotes.

View answer
Why is SUMIF working "selectively" (i.e., not working sometimes)?
Accepted answer
3 votes

If you are after any cell which has ONLY "rdc" (without the quotes), then your formula is fine. If you want any cell which has rdc anyplace in the string, then change it to: =SUMIF(B2:B,"*rdc*",C2:C)...

View answer
I accidentally clicked "split text to columns" in Data Function
3 votes

If you cannot undo and there are not a lot of changes in the file, you can select File->See revision history and get the edit saved prior to the split. If neither of these work, you can use get it ...

View answer
Google Form to a spreadsheet
3 votes

This can be done with the use of Google Apps Script. You can have code fire off when a form is submitted. I used the Tutorial: Simple Mail Merge as a starting point. This allows me to send a custom ...

View answer
Google Sheets - Sum formula that relates with one row to another
3 votes

In the cell where you want to total, place this for the Kinder example: =SUMIF(A11:A, "=Kinder", B11:B) Since your grades are very limited, you could easily edit this for each case. Another option ...

View answer
Is it possible to pull my Company directory into Google sites intranet?
3 votes

Note: Apparently the Domain Service "...was deprecated on May 15, 2014, and will be turned off on November 20, 2014. To manage your domain, use the Admin SDK Directory and Admin SDK Reports advanced ...

View answer
Default folders for new users in G Suite
Accepted answer
2 votes

From the comments, to provide an accepted answer: If you wish to use the classic folders, give them a link to the folder you wish them to access, adding ?usp=sharing to the end of the link. It will ...

View answer
How to add a note (containing date) to a cell in column "X" when it is edited?
Accepted answer
2 votes

You can test the Column the edited cell is in and then act on the cell if it is in the appropriate column. So for Column C: function onEdit(e){ // Set a comment on the edited cell to indicate when ...

View answer
Google sheets conditional formatting relative to another cell in the same column
2 votes

UPDATE FROM COMMENTS: You need 3 custom format settings, all applide to the range B3:B. The First is set to Format cells if... Cell is empty and the fill is set to None The second and third ...

View answer
Transfer google drive / calendar username from @gmail to a custom domain eg. @mysite.com
2 votes

I have multiple accounts for various items, including domains. You can just start using the new account and still keep the old one. If you wish, share access to Calendar and folders until you are ...

View answer
How to create formula for corresponding data across two sheets?
2 votes

Place this in cell E19 =ARRAYFORMULA(if(ISBLANK(C19:C29),, VLOOKUP(C19:C29,Rates!B2:C24,2,False))) It will look up the values from the Rates sheet and apply them, and do this for rows 19-29. If ...

View answer
Dynamically Building Array Of Sheet Names From A Range Of Cells
1 votes

Without any custom function (Google Apps Script) the only thing you could do is have a sheet where you list them all out and reference them in that list. Basically manually make the list and have ...

View answer
Running a script from inside a sheet cell
1 votes

Unless I am missing something, on top of the getA1Notation error from the answer by @Rubén your onEdit function never calls NormalSort(). Change it to: function onEdit(e) { if (e.range....

View answer
Defining a range in a function with the value in a cell instead of a range
Accepted answer
1 votes

Use INDIRECT() to get a cell reference by a string, which in your case is coming from a cell. To use the range as defined in cell C2 but refer to a sheet called data, use: =countif(INDIRECT("data!"&...

View answer
How to mute everyone but myself on a Hangout?
1 votes

In the hangout you will be able to mute each participant individually by selecting them and using the drop down menu (A down-pointing arrow). There are limits to the number of participants. 15 for ...

View answer
If a string is contained in a row return the value of the first cell of the row
1 votes

The Arrayformula can keep you from copying the formula down. For your use, you want to use vlookup to find and return the value. You will only be able to return the values for one matched domain, so ...

View answer
Conditional Formatting on Google Sheets (based on multiple inputs)
1 votes

You want to use a custom formatting based on a Custom Formula So set the Format cells if... to Custom formula is and make the formula: =AND($BK2>80, $BN2>80) This is for a range defined as ...

View answer
Collecting the same email address in a Google Form
1 votes

IF the email is for a google account, you can log in with that account, open the form and go to Responses. Click the 3 vertical dot icon right above the Accepting responses option and choose Get ...

View answer
How do I count instances of a value in a column but only certain rows?
Accepted answer
1 votes

In the Attendance sheet you have a couple options, all based on the formula below: =COUNTA( QUERY(Requirements!A2:F, "select A where A matches '" & JOIN("|", A2:A) & "' and B = 'Yes'", 0)) ...

View answer
Google sheet limit, number of sheets per workbook
Accepted answer
0 votes

There is no reported limit outside the number of cells. There is a limit of 50000 characters in a cell, easily tested by trying to add more, so other limits may be found which are not listed. There ...

View answer
Google Sheets Query to select a large range of columns without manually entering each column
0 votes

As long as your returned columns are continuous and include the item you are checking on, you can use the select *: =QUERY(data!B1:J, "Select * where K = 5") Or some other Where clause that returns ...

View answer
In Slack, how do I find out how many messages per month per channel?
-1 votes

See the article, Review team activity and statistics for instructions to do this. Note that the article states: Who can use this feature? By default, all members except for Guests can view team ...

View answer