7

This has been fixed in Google Spreadsheets. You may now use the F2 key to begin editing without clicking in the cell.


5

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


3

Just like Microsoft's VBScript, Google has its own language - Apps Script. It lets you automate sheets with a Javascript-like syntax, should be easy if you know Javascript. Tutorial and documentation from Google: https://developers.google.com/apps-script To use it, open your Google Sheet file > Tools > Script Editor...


3

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: AMORDEGRC AMORLINC AREAS ASC AVERAGEIF AVERAGEIFS BAHTTEXT BESSELI BESSELJ BESSELK BESSELY BETADIST BETAINV CALL CELL CHIDIST CHIINV CHITEST CLEAN COMPLEX CONVERT COUNTIFS CUBEKPIMEMBER CUBEMEMBER ...


2

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


2

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)) Explanation: INDIRECT lets you construct cell addresses from dynamic input, e.g. from other cells. It supports both A1 notation (as in A2),...


2

Short answer The script should be wrote by and end-user/developer. Explanation 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 ...


2

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.


1

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 while (files....


1

From https://developers.google.com/chart/interactive/docs/gallery/trendlines#exponential-trendlines 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 ...


1

You need following formulas: MAXIFS and MINIFS. =MAXIFS(A2:G2,$A1:$G1,"bar") =MINIFS(A2:G2,$A1:$G1,"bar")


1

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


1

You need to use TEXT, instead of TO_TEXT: =TEXT('90diaspessoas'!A16,"dd-mm-yyyy" ) As long as underlying date number is correct, This will work. OR Set formatting in '90diaspessoas'!A16 correctly to DD-MM-YYYY. Then, TO_TEXT will work. FINAL CONCATENATED FORMULA: =TEXT('90diaspessoas'!A16,"dddd dd-mm-yyyy")


1

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


1

What's the equivalent of the SEP metadata in Google Sheets? There isn't one. is there an all around metadata which could work both on MS Excel and Google Sheets No.


1

Short answer Apply "real" border lines. Explanation The "default borderlines" in Excel and other spreadsheets application are named grid lines. They are a visual aid, not real formatting.


1

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


1

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


1

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


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

Please try: Find: (.+)\) Replace with: $1,0) Search: This sheet (or to suit) Search using regular expressions Also search within formulae Replace all.


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