Smartsheet eBook: Smartsheet User Guide for Accelerated Learning: Powerful Tips to Jump-Start Your Smartsheet Training
Are you looking for the best way to learn Smartsheet– fast? This eBook from Darren Mullen, “the Smartsheet Guru,” was made just for you.
Want to be a valuable and sought-after Smartsheet user for your company or for your clients? The Smartsheet User Guide for Accelerated Learning is your ticket to proficiency with this powerful and popular application.
Distilling years of experience into a collection of the most essential and valuable functions of Smartsheet, you’ll learn:
Smartsheet Formula Fundamentals
- Formula Basics
- Basic Syntax Fundamentals
- Referencing cells
- Row Number or @row Function?
- I have to drag this formula down thousands of rows?
- Absolute References
- Brackets or No Brackets?
- Referencing Ranges
- Cross Sheet References
- Smartsheet Functions
- Function Tooltips
- Function reference via the Toolbar
Nested if Statements
- Writing a nested IF statement
Sheet Summaries
- Creating a Sheet Summary
- Using Formulas in Sheet Summaries
- Syntax to reference sheet formulas
Common Mistakes
- Parentheses
- Missing a required range or value in a function
- Incorrect Column Type
Walk through these practical examples with Smartsheet and then you’ll be ready to charge forward as a Smartsheet master!