KnowledgeCity

Smartsheet: Sheets

Explore the features of sheets in Smartsheet
Preview the first lesson free — get full access to all 6 lessons.

To view this video please enable JavaScript.

Course: On-Demand
Beginner  Provider Darren Mullen  6 Lessons ·  33m  in Arabic, German, English, Spanish, French, Portuguese, Chinese Simplified 

Course Description

No structure can stand the test of time without a solid foundation. In these lessons you will take part in an in-depth exploration of the basic building block in Smartsheet—the sheet itself. You will learn how to create and manage sheets, the features of columns and rows including row hierarchy, and the formatting options available. 

At first glance, sheets look like a regular spreadsheet, but Smartsheet has added additional features such as row hierarchy to better organize and group data within sheets. By the end of these lessons, you will be able to describe how different phases in a project can be grouped in a sheet, how to navigate the row and column menus in a sheet, how to apply formatting to individual cells, and how to automatically apply conditional formatting based on specific criteria.  

What You'll Learn

  • Create and edit sheets to build the basic building block in Smartsheet
  • Manage columns and distinguish between the different column type options
  • Manage rows and explain how to create row hierarchies to organize and group data
  • Apply basic sheet formatting to individual cells
  • Set up conditional formatting that applies automatically based on specific criteria
  • Navigate the row and column menus within a sheet

Key Takeaways

  • The sheet is the basic building block in Smartsheet, and these lessons explore creating and managing it.
  • Although sheets look like a regular spreadsheet at first glance, Smartsheet adds features such as row hierarchy to better organize and group data.
  • Row hierarchy can be used to group different phases of a project within a single sheet.
  • Formatting can be applied to individual cells, and conditional formatting can be applied automatically based on specific criteria.
  • The course covers the features of columns and rows, including the different column type options.

Frequently Asked Questions

What does this Smartsheet course cover?

It is an in-depth exploration of the sheet itself, covering how to create and manage sheets, the features of columns and rows including row hierarchy, and the formatting options available.

What topics are included in the lessons?

The lessons cover Creating and Editing Sheets, Managing Columns, Managing Rows, Hierarchy in Sheets, Basic Sheet Formatting, and Conditional Formatting.

What skills will I gain from this course?

You will learn to create row hierarchies, describe the formatting options available in a sheet, and distinguish between the different column type options, along with skills related to spreadsheets and Smartsheet.

How does Smartsheet differ from a regular spreadsheet?

At first glance, sheets look like a regular spreadsheet, but Smartsheet has added additional features such as row hierarchy to better organize and group data within sheets.

How can data be organized within a sheet?

Row hierarchy can be used to organize and group data, including grouping different phases in a project within a sheet.