Skip to content Skip to site navigation Skip to service navigation

Project Management: Smartsheet Practical Applications

New session times will be displayed below upon confirmation.

Most Technology Training classes will be delivered online until further notice.

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


 

This course is designed for those who have foundational knowledge and skills in Smartsheet that want to get the most out of your project plans.

Smartsheet is a powerful tool for managing project team members, whether they be in the office or working remotely. Discover how you can create a collaborative working hub that facilitates communication among various team members, and learn effective techniques to keep your team current on the status of all project activities and tasks. 

Upon completion, participants should be able to:

  • Implement automation to save time and increase efficiency 
  • Establish dependent relationships between tasks to keep project plans up to date
  • Communicate key metrics to stakeholders

 

Course Content: 

Creating the Base Project Sheet

  • Create a new project file using Import, Template and Save as New options 
  • Transfer the Work Breakdown Structure to Smartsheet Hierarchies
  • Add and configure columns for project use
  • Apply Conditional Formatting
  • Transform the base sheet to a project sheet
  • Adjust the Working and Non-Working days of the plan
  • Create task relationships
  • Adjust the task lag and lead time

 

Finalizing the Project Plan 

  • Use formulas to automate sheet activities
  • Display the critical path to examine the plan
  • Create a project baseline to track the project progress
Don Cameron

Don is the Instructional Design lead in Technology Training, and has been at Stanford since 1998. He teaches collaboration and communication classes, along with courses on Google Apps, Smartsheet, and survey design.

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training


University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.