Tag Info

Hot answers tagged

10

Google Docs Upload your existing files. Google Docs accepts most popular file formats, including DOC, XLS, ODT, ODS, RTF, CSV, PPT, etc. So go ahead and upload your existing files. Familiar desktop feel makes editing a breeze. Just click the toolbar buttons to bold, underline, indent, change font or number format, change cell background color ...


4

Google Sheets allows you to protect specific cell ranges so only certain users can edit them.


3

It looks like you want the & operator I'm not quite clear which thing you are concatenating to which in the question; however, you can do either =$BJ$2 & "24" or =$BJ$2 & BH1 or ="Paper" & BH1 assuming you are on row 2 and the number is on row 1 (the $ locks the cell so that it doesn't change when copying/pasting). Here's an ...


2

Assuming you have a new line character in every cell and you want to extract everything before the new line, try: =ArrayFormula(iferror(regexextract(A2:A, "^(.+)\n"))) (where A is the column with the addresses and your data starts in row 2 --> change to suit). After that, you can copy the output and use 'paste special' (values only) to overwrite to ...


1

Indeed, the first invocation of importrange cannot be nested within another function: the request for authorization does not "bubble up" (at first I thought this was an error on Google's part, but then considered that a single command can combine several importrange within it, so providing an authorization dialog in such a case would be extra complicated). ...


1

I'll stick my neck out (yet!) again and say "No" - based on the deduction that if such existed then most of the many questions asking for a date stamp to be applied when a cell changes would not have been posted. However, that may be a "workaround" for you, ie take one of those scripts and apply it.


1

I have been building an online database application over Google App Engine for such use-cases. It is called iFreeTools Creator. Supports multiple data-types for fields including single-line text, multi-line text, numbers, images, geo-location and more. Forms and views are automatically generated for users based on their authorization profiles. Users ...


1

Another way of doing it, is by using the AVERAGEIF formula. Formula =AVERAGEIF(A1:B1, ">0") Screenshot


1

Here's a function to do thisif a1>0 and b1>0 then average a1 and b1 else add a1 and b1 =if(AND(A1>0,B1>0),AVERAGE(A1,B1),add(A1,B1)) Obviously you'll have to plug in your own cells for a1 and b1 You can find all the google functions documentation here


1

You are using relative reference, which allows the sheet to assume you want to keep the range size the same, just move it. To keep it anchored, you need to use absolute referencing in your formula. This keeps it from moving. =SUM(D$4:D101) Using the $ before the 4 tells it to lock the top of the range to the 4th cell.


1

You can do this using the copyDown add-on by filling in the right formula in line 2. You can find the copyDown add-on here: https://chrome.google.com/webstore/detail/copydown/lipbbdpmkcbplmfnbholpabinnnkbbda


1

Please try, in B2 of Expense_Overview: =sumif(Expense_Detail!D:D,A2,Expense_Detail!C:C) copied down to suit, or: =ArrayFormula(sumif(Expense_Detail!D:D,A2:A,Expense_Detail!C:C)) You have a treat in store whenever you get around to pivot tables. They are very powerful but incredibly easy to use for all that: Select A1:D7 in Expense_Detail, Data, ...


1

You could use the ImportRange function to sync cell data between two spreadsheets. You could then share the individual spreadsheets to your various students. ImportRange documentation: https://support.google.com/docs/answer/3093340?hl=en I've created an example for you, here is your master sheet: ...


1

With the new Google Spreadsheet, you are able to add more than 256 columns. To test this, I added this formula in A1: =TRANSPOSE(REPT("A,", 367)) and continued with this formula in A2 =SPLIT(A1, ",") It will raise an error, telling you to add more columns (it will add 300 as a standard): Once added, the split result will expand and show all the data ...


1

So as I was saying... I couldn't find anything that would let me do this that didn't involve installing a full spreadsheet app so I created a simple CSV transposition tool on app engine: CSV Transposer Tool


1

Copy what you want from the Excel document to MS Word first, and then try to paste it into Gmail by coping it from MS Word.


1

As Gmail doesn't preserve formatting, your options may be to: Copy the file to Google Drive and reference that using the "Insert files using Drive" option Insert a screenshot of the relevant portion of the sheet within the email, if you're particular about formatting and the data isn't a lot


1

You might look at Docs.com, which is Microsoft's free online service. You won't have to do any kind of conversion with the existing spreadsheet documents.



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