Tag Archives: Google Sheets

View deleted files with the latest Google Docs, Sheets, and Slides Android apps

The newest versions of the Google Docs, Sheets, and Slides apps for Android make it possible to retrieve trashed files you unexpectedly need or accidentally delete. Simply select Trash from the navigation menu in your Docs, Sheets, or Slides app, and you’ll be given the option to restore or permanently delete any files that you’ve trashed.



Visit the Google Play Store to download the latest Docs, Sheets, and Slides apps for Android and check out the new functionality.

Launch Details
Release track:
Launching to both Rapid release and Scheduled release

Rollout pace:
Gradual rollout (potentially longer than 3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Delete a document, spreadsheet, or presentation

Note: all launches are applicable to all Google Apps editions unless otherwise noted

Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Explore in Docs, Sheets and Slides makes work a breeze — and makes you look good, too

(Cross-posted from the Google Docs Blog)

We built Google Docs to help you create your best work — from work, school or home, and everywhere in between. We know crafting presentations, projects and reports takes time and energy. That’s why today we’re introducing Explore in Docs, Sheets and Slides to bring you insights, design tools and research recommendations so you can create better work, faster.

Explore uses Google smarts to help you create amazing presentations, spreadsheets and documents in a fraction of the time they used to take…so you can get on with what’s most important in your life. It’s like having a researcher, analyst and designer by your side.

Insights, instantly
Today’s updates to Explore in Sheets help you decipher your data easily, whether you’re new to spreadsheets or a formula pro. Just ask Explore — with words, not formulas — to get answers about your data. You can ask questions like “how many units were sold on Black Friday?,” “what are the top three items by sales price?,” or “what was the total cost of jackets last month?” Less time crunching numbers + crafting formulas = more time to find key insights and use them.

We’ve also added new formatting suggestions to help make your data pop. Explore in Sheets is available on the web, Android and now on iOS, too!



Beauty, baked in
Crafting the perfect pitch deck or sharing your team’s story is hard enough without having to make it look great, too. Explore in Slides makes design polishing simple. As you work, Explore dynamically generates design suggestions, based on the content of your slide. Simply pick a recommendation and apply it with a single click — no cropping, resizing or reformatting required.

We’ve seen that people save over 30% of the time they would have spent on formatting when they use Explore. So even if design isn’t your style, rest assured you’ll have a beautiful presentation to be proud of. Instantly.



Research, made simple
Explore in Docs makes researching and writing reports on the go a whole lot easier. Whether you’re writing about mobile retail trends or planning your next team offsite, you’ll get instant suggestions based on the content in your document. We’ll automatically recommend related topics to learn about, images to insert and more content to check out in Docs on your Android, iPhone or the web.

We know that it’s helpful to refer to other content when writing an analysis, summary or proposal. That’s why we’ve also made it easy to find a related document from Drive or search Google, right in Explore. Less time spent switching between apps more time to polish your ideas.



We designed Explore in Docs, Sheets and Slides to make creating and working easy and most of all, fast — all backed by the power of Google. Let Explore save you time so you can focus on what matters most.

Posted by Ritcha Ranjan, Product Manager

Launch Details
Release track:
Mobile features: Launching to both Rapid release and Scheduled release
Web features: Launching to Rapid release, with Scheduled release coming in two weeks

Rollout pace:
Gradual rollout (potentially longer than 3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: See and use suggested content in a document
Help Center: See and use suggested charts and analysis in a spreadsheet
Help Center: See and use suggested layouts in a presentation

Note: all launches are applicable to all Google Apps editions unless otherwise noted

Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Historical GOOGLEFINANCE data no longer accessible outside of Google Sheets

We want to make you aware of a small change to the GOOGLEFINANCE function, which makes it easy to pull current or historical securities information directly into your spreadsheets in Google Sheets. Starting today, it will not be possible to download historical data or access it outside of Sheets using Apps Script or an API. If you have a spreadsheet with historical data generated from the GOOGLEFINANCE function and you try to download it or access it via Apps Script or an API, the corresponding cells will show “#N/A.” You will still be able to view that historical data from within the Sheets application, and you will still be able to download current data and access current data via Apps Script or an API. Please keep this in mind when using the GOOGLEFINANCE function going forward.

Launch Details
Release track:
Launching to both Rapid release and Scheduled release

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: GOOGLEFINANCE

Note: all launches are applicable to all Google Apps editions unless otherwise noted

Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Google Apps and devices as building blocks for change at ISG



Editor's note: Today we hear from Daniel Durgan, IT Business Partner at ISG, an international construction services company delivering fit out, construction, engineering services and a range of specialist solutions. Daniel explains why there’s never been a better time to digitally transform the construction industry.

The construction industry is undergoing a digital revolution. Companies that have for decades relied heavily on printed contracts, drawings and documents are now moving to online tools to save time and money and keep productivity up in a marketplace that’s more expansive and more demanding. At ISG, we’re using Google’s cloud-based tools to ensure that we’re at the forefront of this industry shift.

With Google Apps, we’re taking full advantage of technology-enhanced collaboration, productivity and mobility. Over the course of a few hours, I can use Google Drive to review a presentation on my tablet, Gmail to check emails and Google Calendar to schedule meetings on my phone while away from the office. I can also jump into a meeting with colleagues from around the world from any of the 26 Chromeboxes that are set up in one of our conference rooms. Whether I’m on a site visit, in the office or on the move, Google Apps allows me to continue working and collaborating with my team.

Projects move fast with real-time collaboration

It’s essential for our business to control who has access to certain documents. Drawings must only be issued to authorised people, and each person must review the latest version as it’s being developed. Drive enables us to completely control what’s shared inside and outside of our company — the fact that our team alone has 1.5 million files in Drive speaks to our reliance on the tool for secure file storage.

Google Docs allows us to collaborate on shared documents at the same time, no matter where we are in the world. I can start shaping up a proposal in London and invite a colleague in Europe to work on it with me. There’s also more of a human element. When someone comments, you see their face next to it — it ties you emotionally to the process. We keep track of all our revisions in Sheets to monitor our progress. And we can always instant message each other with quick questions or suggestions, so we feel connected, all the time.

A lot of what we do is very visual. It’s hard to describe building plans and designs over the phone. With Hangouts, we can bring everyone together to discuss these plans and drawings as if we were all in the same room. We can move quickly from stakeholders to contractors to suppliers to make sure the right people are involved in the right conversations.

Staff expect more from an IT solution

A big part of my team’s role is to help build relationships and ensure employees communicate effectively and get the support they need. When we sent out a survey using Forms to ask all our staff what they’d like to see from IT, they told us they wanted to find out more about our Google tools. We’re using Synergise Google Apps Training to help our stakeholders go beyond the basics and use the suite to its full potential.

Quality: getting it right the first time

Quality is extremely important in our business, so we carry out frequent on-site check-ins to ensure teams are following the proper processes and delivering a high standard of construction correctly the first time. When we do these quality checks, we submit recommendations and observations using Forms on Android tablets. The information is imported into Sheets, and using Apps Script, we create dashboards, so employees across teams and functions can easily track the check-ins in real time.

We’re improving the way we work all the time, and that’s thanks to the support and enthusiasm of our employees. Many of our automated solutions have been suggested by them, and it’s great to see how passionate they are about Google Apps. There’s also an excitement among my team around what the future holds for us and our industry with new tools at our dispense and a new way of working for our customers.

Using Google and Asana to provide more understandable data: Q&A with Looker


Editor's note: Today we speak with Kyle Coleman, Director of Sales Development and Kelly Payne, Customer Programs Manager at Looker, a data analytics software company that makes deep data understandable and useable for business teams. Looker uses Google Apps and Asana to track and collaborate on all their work.
Can you tell us about Looker and why the company needed collaboration and productivity tools?
Kelly: Our team at Looker is building software that helps business teams find, explore and understand the data that matters to them. As a fast growing startup, we think a lot about scaling our team and processes effectively and efficiently. We need the right tools do this well.

Why Google Apps?
Kyle: We’re heavy users of Gmail, Google Calendar, Google Docs, Sheets and Slides. We can easily share our work cross-functionally and always feel confident that the person we’re working with has the most up-to-date version.
Kelly: We’re constantly pulling up a Google Doc to have everyone work from the same place at the same time. There’s a huge benefit to having our work and discussions update in real time and to easily share what we’re working on with anyone in our organization.

How and why does your team use Asana?
Kyle: We use Asana for important cross-functional workflows like new hire on-boarding, sales development and for almost all of our marketing team’s work. From campaign management to launches, every piece of content we publish — whether video, customer case study or blog post — is tracked in Asana. There’s so many moving pieces involved in a complex and collaborative workflow; Asana lets us track every detail.
Kelly: With Asana, we can more easily keep track of who's doing what, and stay updated on the progress of projects. As we’ve grown, Asana has helped us identify how repeated tasks can become standardized processes. Developing process standards brings the clarity and accountability that help us work together well.

How are you using Asana and Google Apps together?
Kelly: We're always linking our docs, spreadsheets or slide decks into our Asana tasks, which is easy to do with the Asana and Google Drive integration. Asana is where we make our work actionable, so the task becomes the place where all the relevant information is stored. Connecting Google and Asana makes it easy to ensure that everyone’s working out of the right documents. We’ve added a good deal of efficiency to our workflow by not duplicating efforts across teams.
How has productivity improved on your team by integrating Asana and Google apps?
Kyle: Two things that matter deeply to us as a growing team are productivity and priorities. Having everything in the same central place saves us so much time as a team, and Google Apps and Asana have given everyone a sense of what they need to be working on and when.

You mentioned that you’re constantly working collaboratively at Looker. How does using Google and Asana side by side make working together easier?
Kelly: With these tools that we’re now using, it’s so much easier to be collaborative and build a sense of trust and empowerment within our team. Whether we’re making a comment in a Google Doc or “hearting” someone’s task in Asana, we’re having a lot more fun moving our work forward together.

We hope you’ve enjoyed reading about how Looker makes work fun and collaborative using Google Apps with Asana. You can learn more and enable Asana in your Google Apps account by visiting their application listing in the Google Apps Marketplace.

See a snapshot of information about a file in Google Docs, Sheets, and Slides

Today, you can view the details of any file or folder stored in Google Drive, including the file or folder owner’s name, the last time it was opened or modified, its location, and more. With this launch, you’ll gain that same capability in Google Docs, Sheets, and Slides on the web.

To see details of a Google document, spreadsheet, or presentation, simply select Document details from the File menu.


Launch Details
Release track:
Launching to both Rapid release and Scheduled release

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

Note: all launches are applicable to all Google Apps editions unless otherwise noted

Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Enhanced third-party access protection for Google Sheets

(Cross posted from the Google Apps Developer blog)

Posted by Tom Holman, Product Manager, Google Sheets and Josh Danziger, Software Engineer, Google Sheets

At Google, we are always working to keep our users' information safe. As part of these ongoing efforts, we will begin requiring explicit authorization when third-party sites request access to Google Sheets content via the Google Visualization API or Google Query Language.

For many developers, this change will be transparent, but others may need to make changes in order to continue reading spreadsheet data. For more details on the technical changes required, please visit the Google Charts API Documentation. We will begin enforcing these requirements on September 14, 2016.

If you have any questions or concerns about this change, please follow up in the Google Docs forum or on Stack Overflow.


Launch Details
Release track:  
Launching to both Rapid release and Scheduled release on September 14, 2016

Rollout pace: 
Full rollout (1-3 days for feature visibility)

Impact: 
Developers using the APIs to access Google Sheets
Action:
Developer action required, if using the affected APIs

More Information

Enhanced third-party access protection for Google Sheets

Posted by Tom Holman, Product Manager, Google Sheets and Josh Danziger, Software Engineer, Google Sheets

At Google, we are always working to keep our users' information safe. As part of these ongoing efforts, we will begin requiring explicit authorization when third-party sites request access to Google Sheets content via the Google Visualization API or Google Query Language.

For many developers, this change will be transparent, but others may need to make changes in order to continue reading spreadsheet data. For more details on the technical changes required, please visit the Google Charts API Documentation. We will begin enforcing these requirements on September 14, 2016.

If you have any questions or concerns about this change, please follow up in the Google Docs forum or on Stack Overflow.

Better tables and charts in the Google Docs, Sheets, and Slides Android apps

The latest releases of the Google Docs, Sheets, and Slides apps for Android make it easy to create tables and improve the look of charts on your mobile phone or tablet.

For instance, starting today, when you copy a body of cells in Sheets and paste it into Docs or Slides, that selection will render as a fully-formatted table, gridlines and all. This will only work for selections of fewer than 400 cells; anything larger will be pasted in a tab-separated format. Note that you will need to update all three apps—Docs, Sheets, and Slides—for this to work.


We’ve also made improvements to the technology that powers charts in Sheets, so you may notice small changes to the way your charts are drawn.

Download the latest versions of the Docs, Sheets, and Slides Android apps from the Google Play Store.

Launch Details
Release track:
Launching to both Rapid release and Scheduled release

Rollout pace:
Gradual rollout (potentially longer than 3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

Note: all launches are applicable to all Google Apps editions unless otherwise noted

Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Announcing Android add-ons for Docs and Sheets

(Cross-posted on the Google for Work blog)

We know many of you consider your mobile device as your primary tool to consume business information, but what if you could use it to get more work done, from anywhere?

We’re excited to introduce Android add-ons for Docs and Sheets, a new way for you to do just that—whether it’s readying a contract you have for e-signature from your phone, or pulling in CRM data on your tablet for some quick analysis while waiting for your morning coffee, Android add-ons can help you accomplish more.

Get more done with your favorite third-party apps, no matter where you are

We’ve worked with eight integration partners who have created seamless integrations for Docs and Sheets. Here’s a preview of just a few of them:

  • DocuSign - Trigger or complete a signing process from Docs or Sheets, and save the executed document to Drive. Read more here.
DocuSign lets you easily create signature envelopes right from Google Docs

  • ProsperWorks - Import your CRM data to create and update advanced dashboards, reports, and graphs on Sheets, right from your device. Read more here.
  • AppSheet - Create powerful mobile apps directly from your data in Sheets instantly—no coding required. Read more here.
  • Scanbot - Scan your business documents using built-in OCR, and insert their contents into Docs as editable text. Read more here.

You can find these add-ons and many more, including PandaDoc, ZohoCRM, Teacher Aide, EasyBib, and Classroom in our Google Play collection, as well as directly from the add-on menus in Docs or Sheets.


Try them out today, and see how much more you can do.

Please note that Android add-ons will the respect same administrative controls as web add-ons. For more information on enabling and deploying add-ons within your organization, check out the Help Center.

Launch Details
Release track:
Launching to both Rapid release and Scheduled release

Rollout pace:
Gradual rollout (potentially longer than 3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Enable add-ons in Google Docs editors
Help Center: Use add-ons & Apps Script

Note: all launches are applicable to all Google Apps editions unless otherwise noted

Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates