Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Smartsheet Advanced
Learn how to use the advanced functionality of SmartsheetPreview the first lesson free — get full access to all 21 lessons.
Advanced Provider : Nick Allgauer 6 chapters · 21 Lessons · 1h 20m in English
Course Description
In this advanced course on Smartsheet, you will learn how to work at a high level of proficiency. We will explore the Smartsheet Admin Center, sheet summaries, formulas, and dashboards. By the end of this course, you will be able to administer Smartsheet features at an account level, utilize sheet summary reports across projects, execute automations and formulas to work across multiple sheets, and use advanced widgets to develop effective dashboards.
Using Smartsheet, organizations can save time and build efficiency into project documentation. Utilizing automations and formulas across sheets can eliminate data duplication and enhance efficiency. Building sheet summaries can provide better context around data, and creating live dashboards can cut time spent reporting and presenting data. The topics demonstrated in this course will build on your existing understanding of Smartsheet and help you operate at a higher level. These step-by-step demonstrations utilize the Business pricing plan currently offered by Smartsheet.
What You'll Learn
- Administer Smartsheet features at an account level using the Admin Center, including user, group, security, and account settings
- Work across multiple sheets using cell linking, automations, and formulas to eliminate data duplication
- Build sheet summaries and reports to provide better context around project data
- Create live dashboards and charts using advanced widgets to reduce reporting time
- Apply formulas for calculations, referencing, and working with dates across sheets
- Manage critical path, summary path, proofing, and sharing within projects
Key Takeaways
- This advanced course builds on existing Smartsheet knowledge to help you operate at a higher level of proficiency.
- Utilizing automations and formulas across sheets can eliminate data duplication and enhance efficiency.
- Building sheet summaries can provide better context around data, and live dashboards can cut time spent reporting and presenting data.
- The Smartsheet Admin Center lets you administer features at an account level, covering user management, groups, security, and account settings.
- The step-by-step demonstrations use the Business pricing plan currently offered by Smartsheet.
Frequently Asked Questions
Who is this course for?
It is an advanced course designed for learners with an existing understanding of Smartsheet who want to work at a higher level of proficiency, building on what they already know.
What topics does the course cover?
It explores the Smartsheet Admin Center, sheet summaries, formulas, and dashboards, including user and group management, security and controls, reports, cell linking, automations, formulas for calculations, referencing and dates, and creating dashboards and charts with advanced widgets.
What will I be able to do after completing it?
You will be able to administer Smartsheet features at an account level, utilize sheet summary reports across projects, execute automations and formulas to work across multiple sheets, and use advanced widgets to develop effective dashboards.
Which Smartsheet plan do the demonstrations use?
The step-by-step demonstrations utilize the Business pricing plan currently offered by Smartsheet.
Are there prerequisites?
The course builds on your existing understanding of Smartsheet, so prior familiarity with the platform is expected.
