Course Description
If sheets are the building blocks in Smartsheet, formulas are used to give life to the structure. In these lessons you will learn the fundamentals of Smartsheet formulas. This includes the proper syntax needed to create formulas, how to find Smartsheet functions, how to reference ranges, and how to use summary fields in sheet formulas.
Learning the fundamentals of proper formula syntax is key as it will allow you to not only create formulas, but also troubleshoot why a formula isn’t working as intended. We’ll also show you where to go to find up-to-date information on Smartsheet functions to create complex, fit-for-purpose formulas.
What You'll Learn
- Create Smartsheet formulas using proper formula syntax
- Reference cells and ranges correctly within formulas
- Find Smartsheet functions to build complex, fit-for-purpose formulas
- Use sheet summary fields within sheet formulas
- Troubleshoot why a formula isn't working as intended
- Locate up-to-date information on Smartsheet functions
Key Takeaways
- In Smartsheet, sheets are the building blocks while formulas give life to the structure.
- Learning proper formula syntax is key because it enables both creating formulas and troubleshooting why a formula isn't working as intended.
- The course covers referencing cells, referencing ranges, and using summary fields in sheet formulas.
- Smartsheet provides a source for up-to-date information on its functions to help create complex, fit-for-purpose formulas.
Frequently Asked Questions
What will I learn in this Smartsheet: Formulas course?
You will learn the fundamentals of Smartsheet formulas, including the proper syntax needed to create formulas, how to find Smartsheet functions, how to reference ranges, and how to use summary fields in sheet formulas.
What lessons are included in this course?
The course includes three lessons: Formula Basics, Referencing Ranges in Formulas, and Sheet Summaries in Formulas.
Why is learning proper formula syntax important?
Learning the fundamentals of proper formula syntax is key because it allows you not only to create formulas but also to troubleshoot why a formula isn't working as intended.
What skills does this course cover?
The course covers skills including Smartsheet, Formula Language, Array Formulas, Excel Formulas, Spreadsheets, and Microsoft Excel.
