Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Smartsheet Formula Training Course
Welcome to the Smartsheet Formula Training Course
Welcome and Introductions (1:36)
What to Expect (2:23)
How to get the most out of this course (1:13)
Intro to Formulas
Formula Overview - what they are, why you want them, and a conceptual look at how they work. (5:11)
Where to use Formulas in Smartsheet (19:13)
Top Formulas To Know
COUNT, COUNTIF, and COUNITIFS (6:52)
SUM, SUMIF and SUMIFs (7:42)
VLOOKUP (2:07)
REPLACE (1:07)
DAY and DATE (2:07)
NETWORKDAYS (1:14)
ISBLANK (1:46)
MAX (1:33)
MIN (1:01)
MEDIAN (0:51)
ROUND (0:49)
IF (1:44)
Request a Formula Video (0:51)
Advanced Formula Strategies
Cross-Sheet Formulas (6:27)
Nested Formulas (3:45)
Troubleshooting Formulas
#BLOCKED (3:23)
#CALCULATING (1:26)
#INCORRECT ARGUMENT SET (2:12)
#NO MATCH (1:34)
#UNPARSEABLE (4:47)
Help With Other Errors (0:32)
Dashboards & Reporting
Dashboards (8:54)
Continue Your Learning...
Get My Smartsheet Dashboard Training Course
Learn Smartsheet Formulas here...
Other Ways To Learn More... (1:12)
Extras
Useful resources
Require Smartsheet Consultancy?
Teach online with
How to get the most out of this course
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock