Class Code
Class Description
Note: This is a fully in-classroom session and will not be held on Zoom. Please consider not enrolling if you are unable to attend in-person. All participants will need to adhere to the Stanford Health Check guidelines.
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