Skip to content Skip to site navigation Skip to service navigation

Smartsheet In Action: Functions and Formulas to Streamline Your Data

Class Code

ITS-2055

Class Description

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.

 


 

Become proactive with your Smartsheet data. This session will introduce you to best practices for creating Smartsheet Formulas, along with such Functions as COUNT, COUNTIF(S), SUM, SUMIF(S), VLOOKUP, and INDEX MATCH.

 
Prerequisite: Participants should have attended the Smartsheet Basics class, or have equivalent experience.

Course Objective: Given a Smartsheet with analytical data, learners will have the opportunity to update fields in a spreadsheet with the following functions:

  • COUNT
  • COUNTIF
  • COUNTIFS
  • SUM
  • SUMIF
  • SUMIFS
  • VLOOKUP
  • INDEX MATCH

Topics covered include:

  • Create basic formulas
  • Basic functions such as SUM, AVG, and IF
  • Incorporate functions in the CHILDREN hierarchy
  • Pull data from another sheet using a sheet reference
  • Functionality of the COUNT and SUM functions
  • Best practices of the VLOOKUP and INDEX MATCH function, including pros and cons

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.