There is a free application known as TrelloExcel out there. I've been using it for about a week or two now - https://github.com/dillenmeister/TrelloExcel
It will very nicely export/import data, but it doesn't seem to handle updating existing items. For what you need it for, I think it will work to get you the task name, description, and due date (but no ...
Tutorial and documentation from Google: https://developers.google.com/apps-script
To use it, open your Google Sheet file > Tools > Script Editor...
If you want to make sure that MS Excel 2010 files are properly converted and still work in Google Spreadsheets, then don't use the following formula's:
This is a bit off topic because it doesn't answer the question of Excel exporting, but it does address the side of good solutions for burndown charts. We use Trello Burndown from Blue Line Game Studios. It does a pretty good job and everyone can update their piece so it's not dependent on sharing an excel spreadsheet. You can find that at http://...
The script should be wrote by and end-user/developer.
Google Sheets doesn't include a way to automatically convert VBA code to Google Apps Scripts.
By the other hand not all the VBA statements, classes, methods, etc. have an equivalent on Google Apps Script and not all the Excel features have an equivalent on Google Sheets, so ...
Seems your Excel is set to the 1904 date system (more likely for Mac users than PC users). This is an Excel option. Dates in Excel are index numbers that by convention start either in 1900 or 1904.
The setting may be changed in Excel under Options > Advanced > When calculating this workbook.
This is a job for the INDIRECT function. For the sum in A8, use
=SUM(INDIRECT("R2C" & B8 & ":R5C" & B8; FALSE))
Likewise, for the sum in A9, use
=SUM(INDIRECT("R2C" & B9 & ":R5C" & B9; FALSE))
INDIRECT lets you construct cell addresses from dynamic input, e.g. from other cells. It supports both A1 notation (as in A2),...
Rich-Text formatting is not an OPT in/out / turn on/off feature. It's always turned on. To use it:
Put the cell in edit mode
Type the text
Select the text part to apply bold, italics, color
Apply the desired format by using the Google Sheets toolbar or keyboard-shortcuts like Ctrl+b for bold, Ctrl+i for italics, etc.
Put the cell in display mode (press ...
You need to use TEXT, instead of TO_TEXT:
As long as underlying date number is correct, This will work.
Set formatting in '90diaspessoas'!A16 correctly to DD-MM-YYYY. Then, TO_TEXT will work.
FINAL CONCATENATED FORMULA:
As far as I am aware, this is not possible, given Excel's incompatibility with Google Apps Script.
There is an alternate and only slightly less efficient solution, though: each time you want to analyse the results of your Form, simply download the connected Google Sheet as an Excel spreadsheet, open the downloaded spreadsheet in Excel, and do your analyses ...
I'm no Excel guru, but I think this page on the CommCare Help Site goes through the steps to do at least some of what you're talking about: https://confluence.dimagi.com/display/commcarepublic/Tutorial%3A+Create+an+Excel+Dashboard. The key might be starting at "Step 4: Name your raw data for easy reference later" where is shows you how to mark all rows in ...
There is no current functionality to do this (I'm not on the Beta, so I cannot test the Bulk Export functionality currently on offer, although it doesn't look like its what you need).
However, there is a card on the Ideas stack (sort of a feature request list), entitled CSV or Other Export. This looks like more what you want - however it's not implemented ...
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
The way you've stated it, that this is not a FORMATTING problem: you need to use a FORMULA to combine the data you have into a new data-value, in a new cell.
The nice thing about using a spreadsheet for this is that it's dynamic: if your source data changes, your derived data changes at the same time.
However as others have stated, the gmail anti-...
You don't have to create in one go the whole string because some clients have limitations regarding the number of recipients. You can simply create the desired format for each row and then select the ones that you want and paste them in client's field for BCC. You don't have to worry about the fact that you're copying cells instead of the string, because ...