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 ...


2

I've shared a sheet for you to play with here. There is a fourth sheet to help write the second solution The simple solution (with only numeric ids) is quite straightforward: =MAX(Sheet1!A2:A,Sheet2!A2:A, Sheet3!A2:A) (This assumes each column has a title) The situation with a prefix works like this: ="R" & MAX( ...


1

There is no default way to do it through UI of google docs. However, I have written a small script that you can use on your google docs spread sheet to add rows. function addRows(){ var sheet = SpreadsheetApp.getActiveSheet(); var rows = sheet.getDataRange(); var numRows = rows.getNumRows(); for (var i = 1; i <= numRows*2 - 1; i+=2) { ...


1

You can do it for first row and then drag the formula to next rows in the column. Just go to the corner of the cell where you have already applied, the arrow will become a cross hair. Drag it to next rows. The formula will be automatically updated till the final cell where you drag and values will be calculated.


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

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



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