In this release, we’ve added some features around pulling and refreshing data from Salesforce along with a handful of enhancements.
- You can now transpose rows to columns when pulling or refreshing reports and SOQL queries. To enable this, check the Transpose columns to rows checkbox under Options:
- You can now define a cell in your workbook that will be updated with the last refresh date for reports and SOQL queries. You can use a cell address on the same worksheet (e.g. A10), a cell address on a different worksheet (e.g. Sheet1!A10), or a named range here:
- When pulling data via SOQL, you can now have field labels instead of API names as headers when Show object and field labels instead of API names option is checked: