Register/Launch Live Training
| Event | Date | Spaces left |
|---|---|---|
| Formula Basics | 23 | |
| Formula Basics | 45 | |
| Formula Basics | 48 |
Formula Basics
Learn the foundations of Formulas and the application of common scenarios in Smartsheet such performing calculations and lookups within and across multiple sheets
This course introduces the learners to the foundations of Formulas and the application of common scenarios in Smartsheet such performing calculations and lookups within and across multiple sheets.
Learning Objectives:
At the end of this course, participants will be able to:
• Write formulas using basic operations including accessing data from/to sheet summary fields
• Write conditional statements using IF() and nested IF()s to update symbol columns and drop down lists
• Calculate numeric values or automate aspects of the sheet by using formulas based on the hierarchy (i.e. CHILDREN(), and ANCESTORS())
• Write formulas that use ranges and criterion (i.e SUMIF())
• Apply additional functions such as JOIN() and SUM ()
Duration: 120 minutes
Maximum Number of PDUs: 2
Audience: This course is intended for licensed Smartsheet users who have little to no experience with formulas.
Prerequisites: Knowledge of working with sheets, including sheet creation and column types
Features Covered:
• How to write and read formula syntax in Smartsheet
• Formulas based on Hierarchy
• Formulas using other sheets
• Using the Formula Template
• Using the Function List from the Learning Center
• Using the Community as a resource to lean about formulas
Questions?
Contact training@smartsheet.com
-
Register/Launch Live Training
- Pre-Class Material
-
Video: Formula Basics (2:45m)
-
Video: Cross-sheet Formulas (1:58m)
-
Download the Formula Template Sheet
- In-Class Material
-
Download assets for the class
-
Content and Activities
-
Content and Activities (PDF Version)
- Next Steps
-
Share your Feedback!
-
Video: Taking formulas to the next level (41:04m)
-
Course PDU Information