At Spreadsheet.com we're serious about enabling you to build powerful project management solutions and custom no-code apps for work. That's why we're excited to announce two major new features in a series of launches we'll be making over the next few months:
1. Reports: A new document type allowing you to create a single view of data from multiple worksheets and workbooks to literally keep everyone on the same page. 🗂
2. Gantt 2.0: Improvements to Gantt views and new project management capabilities let you plan and manage projects like a pro, including support for all industry-standard dependency and constraint types, constraint dates, and lag times. 🏆
In addition, we published 18 new templates along with new use case guides and work management articles.
Let's take a look!
Reports are a new entity type in Spreadsheet.com that allow you to pull data from multiple worksheets and workbooks into a single combined view that can be shared with anyone on your team.
Reports update in real-time and can be filtered, sorted, grouped, and printed, just like worksheets.
Reports are a paid plan feature, with plan limits as follows: – Standard: Unlimited reports, 2 worksheets per report – Premium: Unlimited reports, unlimited worksheets per report – Enterprise: Unlimited reports, unlimited worksheets per report
Meanwhile, stay tuned for even more reporting features coming soon such as the ability to send reports as PDF or Excel docs on-demand, or automatically at scheduled intervals (e.g. the end of each month).
Dependency Types and Lag Times
Spreadsheet.com now supports task lag times and all four industry-standard dependency types used to determine the relationship between a task and its predecessors’ start and finish times:
Spreadsheet.com now supports task constraint dates and all eight industry-standard constraint types, which are used in conjunction with dependency types and lag times to further control when a task starts and finishes based on start and finish dates of predecessors, and an optional constraint date:
– As Soon As Possible (ASAP) – As Late As Possible (ALAP) – Finish No Earlier Than (FNET) – Start No Earlier Than (SNET) – Finish No Later Than (FNLT) – Start No Later Than (SNLT) – Must Finish On (MFO) – Must Start On (MSO)
This combined with our all new task scheduling algorithms provides a rich project management experience within Gantt views, allowing tasks to pull and push dependencies in the same ways experienced project management software users are familiar with.
Two new column data types are now available in worksheets with Project Management enabled called Constraint Type and Constraint Date. You’ll need to add these columns to your worksheet in order to edit constraint settings.
The Gantt chart canvas in Gantt views is now draggable using your mouse, not just the laptop trackpad. Grab and hold the canvas to move it in any direction. A much faster and easier way to home in on the project region you want to look at and work with.
In addition, we published 18 new templates for use cases ranging from Software Development Project Planning to Project and Event Budgeting, Communication Planning, Event Planning and Budgeting, and more.
For example, the Software Development Project Plan template is designed for managing a development project from end to end with a task list, objectives, assignments, dates, statuses, Gantt views, and Calendar views.
Rich Text Data Type We’re working on a new data type allowing rich formatted text in cells with markdown support, a popular feature request.
Dashboards Create and share documents with text and embedded widgets that leverage data from workbooks and reports to visualize information in a variety of ways such as Views, Charts, key metrics, videos, and more.
Row Movement Ability to drag and drop rows to reposition them in a Sheet view. This includes the ability to move parent rows in a hierarchy and have all child rows move with them.
Drag & Drop Cell and Range Movement Similar to traditional spreadsheets, we’re adding the ability to drag and drop individual cells and ranges to move them in the grid.
Mobile Apps V1 of the Spreadsheet.com mobile app for iOS and Android.
Stay tuned for these and more updates coming soon ...