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://...
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),...
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.
Google Sheets has hard-and-fast limitations. One of them is that no spreadsheet may have more than five million cells total among all sheets/tabs. If you are trying to upload 1M rows, and those rows each contain more than 5 cells each (which is likely), you'll have exceeded this number (in fact, 1M rows with 5 cells each completely maxes the space limitation)...
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, Ctrl+k to insert a link, etc.
Put the cell in ...
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:
Try using the EDATE() formula. Since it adds months you'll need 240. Something like this:
Then paste values.
Alternatively, you could use this formula:
An option is to output the file name as well as the HYPERLINK() function. This should allow you to:
sort the output,
lookup the file name and return hyperlink (or vice versa, according to your preference)
In this snippet, str is the hyperlink and str2 is the name of the file.
The final line of code is simply setValues rather than setFormulas
Note: Unlike linear trendlines, there are several different ways to compute exponential trendlines. We provide only one method right now, but will support more in the future, and so it's possible that the name or behavior of the current exponential ...
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 ...
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 have tested 2 tools allowing to export trello data to Excel:
Directly in Trello, you can subscribe to their Business Class package and export all cards from all boards in one operation. See their help page here. https://help.trello.com/article/747-exporting-data-from-trello-1
You can use the add-on Bridge24 for Trello. That tool allow you to select ...
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