
Explore the uses and components of Smartsheet, from reports and forms to workflows. Learn to create sheets, import Excel, format with styling, collaborate, use formulas and filters, and publish content.
Watch this essential information to maximize your training experience, including downloading and unzipping instructor files from the next module and adjusting playback speed in high-definition video.
Explore how Smartsheet supports personal and team work through sheets, forms, automation, and project management tools, enabling collaboration, attachments, budgeting, and automated documents.
Explore Smartsheet components: sheets, reports, dashboards, and forms, and see how views like Gantt charts, calendars, card views, and timeline views illuminate project data and collaboration.
Explore the Smartsheet interface in the browser, mastering navigation from home, search, and notifications to creating new projects, managing sheets and workspaces, and organizing favorites.
Learn to create a new Smartsheet from grid view, define a primary task column, and configure description, assigned to, status, start and end dates, and indented hierarchies.
Import Excel documents into Smartsheet by selecting import, choosing Excel, and mapping column headings. Name the sheet 'Aurora project content' and apply hierarchy and formatting for a clean grid.
Format numbers as dollars and adjust decimals; apply the long date format and resize columns. Learn to freeze panes and use the more options menu with Smartsheet help links.
Learn to use conditional formatting in Smartsheet to color-code statuses, apply colors based on the assigned to column, and set budget thresholds, applying rules to cells or rows for visibility.
Switch between grid, timeline, board, Gantt, calendar, and card views in Smartsheet to tell stories, manage status and priority, and explore baselines and time scale settings.
Master comments and attachments in Smartsheet to collaborate, using conversations, mentions, and file uploads to rows and sheets.
Learn how to set reminders and update requests in Smartsheet to keep tasks on track by assigning reminders, sharing sheets, and configuring recurring updates by column.
Share with permissions (admin, editor, commenter, viewer) and switch views (grid view, card view, Gantt view) before exporting to PDF, Excel, Google Sheets, or PNG for attachments with optional comments.
Publish your Smartsheet as a web-friendly URL or embed code, choose grid, card, calendar, and Gantt views, and set access controls.
Explore how Smartsheet formulas work, including summing child cells, using the sigma function, and applying column formulas to automate calculations.
Explore sheet summaries in Smartsheet to roll up key data with custom fields, linking to cells, formatting currencies, and building formulas like countif for quick project insights and reports.
Learn how to create and apply filters in Smartsheet to control what items you see, share filtered views, and spotlight under budget or completed tasks.
Learn how to set up and use Smartsheet workflow automations to trigger alerts, reminders, or row moves from templates or from scratch, with dynamic recipients and custom messages.
Explore creating reports in Smartsheet using the report builder to bundle source sheets, filter and group data, summarize budgets, and publish varied views to share insights.
Learn how to create forms from existing sheets in Smartsheet, customize fields, validation, layout, and sharing options to streamline project data collection.
Review Smartsheet components such as reports, workflows, forms, and sheets; learn formatting, conditional formatting, collaboration, formulas, filters, and publishing for shared work.
This course includes downloadable course instructor files to work with and follow along.
Smartsheet for Project Management and Collaboration is designed to help you unlock the full potential of Smartsheet, whether you are a beginner or have some experience with the platform.
This course provides a broad overview of Smartsheet’s essential features and functionalities, enabling you to manage projects, collaborate with your team, and organize data efficiently. You will explore various applications of Smartsheet across different industries, allowing you to tailor the tool to your specific needs.
Throughout the course, you will learn how to create and customize sheets from scratch or by using templates, ensuring your projects are well-structured and organized. You will learn to import Excel documents into Smartsheet while maintaining data integrity and applying conditional formatting to make your data visually informative. The course also covers different sheet views, including Grid, Gantt, Calendar, and Card, helping you choose the best view for tracking your projects.
Additionally, you will enhance collaboration by adding comments and attachments directly within your sheets. Learn to create sheet summaries that overview key metrics and data points. Gain practical skills in using formulas and filters to analyze data effectively, discover how to generate insightful reports, and set up automated workflows to streamline your processes. By the end of this course, you will know how to boost your productivity, improve your project management skills, and effectively leverage Smartsheet to achieve your goals. This course is perfect for project managers, team leaders, and administrative professionals looking to enhance efficiency and collaboration in any work environment.
Learning Objectives
In the course, you will learn how to:
Explore various Smartsheet applications across different industries.
Create and customize sheets from templates or from scratch.
Import Excel documents while maintaining data integrity.
Apply conditional formatting to highlight important data.
Utilize Grid, Gantt, Calendar, and Card sheet views.
Add comments to enhance team communication.
Attach files to sheets for better collaboration.
Create sheet summaries to overview key metrics.
Use formulas to calculate and analyze data.
Apply filters to organize and view data effectively.
Generate reports to track project progress.
Set up automated workflows to streamline processes.
This course includes:
104 minutes of video tutorials
20 individual video lectures
Course Files to follow along
Certificate of completion