Skip to content Skip to site navigation Skip to service navigation

Smartsheet Basics and Best Practices

Class Sessions

Date Delivery Method Cost
  • Tue Jun 20, 9:00 am to 12:00 pm
Birch Hall 105 (Birch Lab A) - 1 session $300
  • Wed Jul 26, 9:00 am to 12:00 pm
Live Online - 1 session $300

Class Code

ITS-2050

Class Description

Before each sesson, Tech Training will provide a Zoom link for live online classes, along with any required class materials.

Note: This class offers an option for online and in-classroom sessions. Participants attending an in-person class will need to adhere to the Stanford Health Check guidelines.

 


 

Explore the basics of creating and managing work within a single sheet. You will be introduced to cell linking, reporting, and automated alerts and actions. You will explore the different Smartsheet views and how these views can maximize engagement and organization. You will also find out more about the many ways to collaborate inside of Smartsheet through sharing, sending, publishing, and update requests to internal and external collaborators.

 

Discover how Smartsheets can help increase work agility and collaboration by providing a powerful platform for planning, organizing, managing, reporting, and automating work.

 

Pre-requisites:

Students should have a basic knowledge of Excel.

 

Upon completion, participants should be able to:

  • Implement organizational best practices to increase readability
  • Use the appropriate Smartsheet features to collaborate effectively
  • Visualize your work by leveraging all the views in Smartsheet
     

Course Content:
 

Create

  • Maneuver Smartsheet environment by learning how to create and organize your work
  • Organize work with hierarchies
  • Edit columns to improve sheet functionality
  • Increase efficiency with different formatting and viewing
  • Centralize communication with the use of comments and attachments
  • Create basic formulas
  • Introduction to the views: Gantt, Calendar & Card
  • Fundamentals of Project Management in Smartsheet


Collaboration

  • Use update requests to obtain information from external collaborators
  • Build conditional formatting rules to visually track updates and information
  • Set up automated alerts and actions to notify collaborators
  • Set row and sheet level reminders


Communication

  • Send work via sending a row and sending a sheet
  • Share work by inviting collaborators and assigning permission levels
  • Print and publish sheets to allow greater audiences to view your work

University IT Technology Training classes are only available to Stanford University staff, faculty, students, and Stanford Hospitals & Clinics employees, including Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health. A valid SUNet ID is needed to enroll in a class.