Holding monitor of how your massive office initiatives are progressing may quickly be much more simple due to a brand new Google Sheets (opens in new tab) replace.

The spreadsheet software program (opens in new tab) is introducing a brand new timeline view that it says will present a clearer and extra intuitive perspective on how your work is progressing, and supply challenge administration instruments throughout the platform for the primary time.

The brand new view, described by Google Workspace as a “visible layer” shows challenge data saved in Sheets, reminiscent of the duty begin and finish date, description, and proprietor. Customers can even view extra details about the challenge within the sidebar by clicking on a card throughout the timeline, and in addition monitor progress over time by accessing up to date variations of the timeline at varied time intervals (day, week, month, quarters, yr, and multiyear). 

Google Sheets timeline

“The timeline view allows you to simply work together with challenge data and can assist you handle issues like advertising and marketing campaigns, challenge milestones, schedules, cross-team collaboration, and extra,” a Google Workspace replace weblog publish (opens in new tab) asserting the information famous.

To create a timeline, customers might want to head to Insert > Timeline > choose a knowledge vary > configure the attributes within the timeline settings sidebar. When created, customers will then be capable of entry plenty of choices, together with with the ability to view the timeline at totally different time intervals, soar to the present date, and altering the visible look of the timeline by adjusting spacing or utilizing colours. 

The function is rolling out now to most Google Workspace customers, together with Google Workspace Necessities, Enterprise Commonplace, Enterprise Plus, Enterprise Necessities, Enterprise Commonplace, Enterprise Plus, Training Fundamentals, Training Plus, Training Commonplace, the Educating and Studying Improve, and Nonprofits prospects. Nonetheless legacy G Suite Fundamental and Enterprise prospects, and customers with private Google Accounts, will not be capable of entry.

The announcement is the newest new addition to Google Sheets as the corporate seems to be to maintain the device helpful and intuitive for customers in every single place.

This contains not too long ago enhancing the drag-and-drop expertise, that means Slides customers can insert content material like textual content and pictures straight right into a presentation from one other app. The corporate says it hopes the replace “enhances flexibility by providing you with extra methods to work with, show and arrange your content material”.

One other important improve added Google’s “individuals chips” to Sheets, that means that by typing “@” whereas in a spreadsheet, customers will be capable of shortly view extra details about their colleagues or contacts together with their location, job title and get in touch with data. Individuals chips may also be used to take actions reminiscent of reserving a gathering in Google Meet, beginning a chat, sending an e-mail and extra.

• We have additionally rounded up the most effective productiveness instruments