Views let you take a worksheet and transform it, helping you see and work with its data in entirely new ways.
When you’re creating workbooks in Spreadsheet.com, you don’t have to stick with the traditional spreadsheet grid. Adding different Views to a worksheet lets you transform it into something else entirely – like a fully-featured calendar, a Kanban board, or an interactive Gantt chart – in just a few clicks.
Adding a new View gives you a new way of seeing your data while maintaining a single source of truth. When you change information in a View, the underlying data changes in your original worksheet, and vice versa.
Spreadsheet.com supports five types of Views: Sheet Views, Kanban Views, Calendar Views, Form Views, and Gantt Views.
A Sheet View – the traditional spreadsheet grid with Spreadsheet.com’s powerful features layered on top – is the type of View that all new workbooks are created with by default.
A Kanban View takes your worksheet rows and transforms them into cards laid out on a Kanban board. Cards are “stacked” by the information in a selected worksheet column.
A Calendar View transforms your spreadsheet into an interactive, fully-featured calendar. Share your calendar using iCal link sharing, and your team can automatically import events into calendar applications like Outlook and Google Calendar.
Adding a Form View lets other people add data to your worksheet via a shareable form, even if they don’t have a Spreadsheet.com account. Form responses are automatically added to your worksheet as new rows.
A Gantt View adds an interactive Gantt chart side-by-side with your worksheet, with support for key project management features like task dependencies and constraints. Gantt Views make the most of Spreadsheet.com’s powerful project management features.
All of the Views shown above are built from the same Sheet View. Views remain linked to their source data – when you make changes in one View or in the original worksheet, the changes are reflected in all other Views.
Worksheets can have any number of Views, and Views can be renamed or deleted at any time.
How to Add a New View to Your Worksheet
- Click the View name or Pin Views Sidebar button to open the Views sidebar
- From the Views sidebar, click one of the New View… buttons at the bottom
- Specify the name and access level of your new View
Learn More: Working with Views
Creating Views in your Spreadsheet.com workbooks can make them more powerful and versatile than any traditional spreadsheet. Learn more about working with Views with these resources:
- “Introduction to Views” – Learn more about Spreadsheet.com’s different Views, including managing your existing Views
- “Kanban Views” – Learn more about working with Kanban Views
- “Calendar Views” – Learn more about working with Calendar Views
- “Form Views” – Learn more about working with Form Views
- “Gantt Views and Project Management” – Learn more about working with Gantt Views and the full suite of Spreadsheet.com’s project management features
Next, we’ll take a look at organizing your worksheets with filtering, sorting, and grouping rows.