The Stack Overflow podcast is back! Listen to an interview with our new CEO.
7

Use regular expression in Find and Replace: ^\s*$


7

I couldn't find an absolute setting to just disable this function. However, you can disable the function from continuing to create links or start creating links in a new document simply by selecting all the cells (Ctrl+A), right-click and select "Unlink" from the options menu. As soon as you do this, Google Sheets saves the change and no hyperlinks will ...


4

You can just press the Enter key and it should start editing your current cell.


4

In Google Sheets, as in some other spreadsheet apps, typing a single apostrophe at the beginning of your entry will prevent the software parsing your input. Type '=Hello and =Hello will appear in the cell.


3

Old question, but I think this solution may be worth it. You can use a custom script function which retrieves the column index (i.e. A, B, C...) using a header name, allowing to do something like: =query('MySheet'!A2:Z; "select "&colIndex("'MySheet'!A1:Z1"; "Car name")&" where "&colIndex("'MySheet'!A1:Z1"; "Car color")&"='Blue'"))...


3

Simplifying fractions can easily be done with the GCD-function (Greatest Common Divisor). Using this function =A1/GCD(A1;B1) & ":" & B1/GCD(A1;B1) will give you this result: A B C 1 2 5 2:5 2 5 15 1:3 3 8 18 4:9 If you really want half points, just multiply all values with two and at the end divide them by two again: =(2*A1/...


3

The way I do it is: place the date in row A1, in row A2 using the formula do = A1 + [number of Days] Eg.: A1 [11/12/2018] A2 [=A1+3] A2 [November/15/2018] (I format the date with an easy to interpret format (select row > Format > Number > More Formats > More date and time formats)


3

If you're trying to copy down a value that you just entered/typed into the cell above, then you can use F4. (F4 in Excel and Google Sheets does something along the lines of "repeat the last thing I just did".) You might want to adjust your keyboard settings if you want to use this frequently so you don't have to hit fn + F4 every time since on most new ...


3

I already mentioned this on a recent question When sharing folders on Google Drive do users know who else the folder is shared with Users that are explictely included on the sharing settings could see who else has access to the file. To prevent this, create a Google Group, add the collaborators (editors/viewers) to that group then share the folder ...


3

I had the same question, and found some Google's Product Forums that this is not possible: https://productforums.google.com/forum/#!msg/sites/IIr76F7R2sM/KlAw1lCMDQAJ For a workaround I'm making the background color of the chart the same as the slide.


3

Say I'm forgetful, but I don't want to pester my coworker by calling her more than every two hours. I might remind myself just by jotting down when I call, so I can glance at that note next time I'm once again reaching for the phone. A script could do the same, scribbling down when it needs to run again, and checking it later. function onOpen() { var ...


3

Add getValue() to var r = sheet.getRange("D11");. The resulting code line is: var r = sheet.getRange("D11").getValue(); The above because getRange returns Range object which not return directly it's value/values. Also replace r.hideRows(11); by sheet.hideRows(11); For further details checkout https://developers.google.com/apps-script/guides/sheets


3

The best way to handle sharing files with large and dynamic groups on Google Drive is by using Google Groups, but it's also possible to do the way you are thinking by using Google Apps Script or the Google Drive API and the Google Sheets API To use a group from Google Groups to handle sharing files, share the files with the group by adding its email address....


3

Instead of date 'TODAY()' use date '"&TEXT(TODAY(), "yyyy-mm-dd")&"'" NOTES: The last " should be placed in a proper place in order to have a text value as the second argument of QUERY. 'TODAY()' doesn't returns Today's date, it returns a string with the word TODAY followed by parenthesis. Try this =ARRAYFORMULA(QUERY({A3:H, HOUR(A3:A)}, "...


3

Your formula is correct. You just need to use single ' instead of double " quotes. =INDEX('Value Reference'!B2:AJ6,MATCH(B4,'Value Reference'!A2:A6,0),MATCH(B5,'Value Reference'!B1:AJ1,0)) EDIT Make Data validation dynamic You can improve your results even further. Instead of using List of items for your Data validation, you can use List from a range. ...


3

Yes, it is parameter linewidth. Example : =SPARKLINE(L4:L;{"linewidth"\3}) Reminder on how to construct a =sparkline : =SPARKLINE("range",{"charttype"\"line","xmin"\0,"ymin"\0,"color"\"orange","empty"\"ignore","linewidth"\6}) More on sparkline here.


3

I modified the excellent code provided by Jacob Jan Tuinstra to fit your needs assuming your data starts at A2. Step 1 Open the Script editor from your sheet menu and paste this code: function result(range) { var output2 = []; for(var i = 0, iLen = range.length; i < iLen; i++) { var s = range[i][1].split(","); for(var j = 0, jLen = s....


3

2nd EDIT (following OP's request) "I need a solution that gets me all the way from having a list of filenames (what I have now) to having a list of links I can click on and get to the corresponding file. Incomplete answers like "write a custom menu that uses DriveApp.getFilesByName" won't be accepted" 1. On the spreadsheet's menu find Tools and click on ...


3

You can build a custom parser for any fixed JSON string using regular expressions. For example, if you want to extract the child items into columns you can do the following (assuming your JSON string is in A1): =SPLIT(REGEXREPLACE(INDEX(REGEXEXTRACT(A1,"(\[(\n|\s|""|\w|,)+\])"),1),"(\[|\]|\n|\s|"")",""),",") You can adapt this formula to suit whatever ...


3

With a regex, you can replace each character with itself + ','. Then use a regular split function. =split(REGEXREPLACE(A1,"(.)","$0,"),",",true,true)


2

To move a range of cells to a new location in Google Sheets: 1. Select the range of cells you want to move 2. Move your mouse to any edge of the selection until the cursor changes into a hand 3. Drag your cells to the new location This does what it should - it moves them - so all cell information will remain exactly as they were in their original ...


2

here's a useful reference: Review guidelines for customizing a number format It's a link to support.office.com's guidelines for Excel number formatting - broken down into sections on how to include text, decimals, spaces, colors, currency types, date and time formats, etc...


2

On Firefox used Alt + Up and Alt + Down to move the worksheet and avoid conflicts with moving the browser tab.


2

option up/down arrow works for me on my mac ( as of today ) Before it was the clumsy Cmd + Shift + Fn + Down arrow as described by Jacob. that combo was unusable for me.


Only top voted, non community-wiki answers of a minimum length are eligible