
Master Smartsheet essentials to manage team workflows, build dashboards, share workspaces, and automate processes with AI tools, forms, and cross-sheet links for reporting and architecture.
Logging to Smartsheet using trial License.
We will see all the options of Side bar, and Specially the browse option which we will use very frequently
Creating first sheet and basics of all Column options
Explore dates and duration management in smartsheet by converting progress to percentages, adding a start date and duration columns, and calculating task timelines with column formulas.
Assignement Solution
Importing Google Sheets or Excel into new created Sheets
Sharing the sheets with different users, and trying to change the level access for users
Importing the contacts from Microsoft Outlook, manging contacts and Contact groups
How to use conditional formating to bhighlight Row or particular Cell. Learn how to define multiple rules.
Filters and multiple rules applied on it
Formating options for changing the cell value visuals
Uploading attchments on row and sheet level. We will learn how to access these attachments.
Adding proofs for review process and utilizing it for approval process as well. Manging proofs at row level.
How to use chat or Coversatin options effectively and capture the reply outside smartsheet. Mange the conversation on sheet and row level.
Setting up notification for reminders at row level.
Update request for getting info or data from outside smartsheet.
Place an update request on a row, include the status and percentage complete columns with the reminder box checked, and verify others update to started, in progress, or completed.
Set one-time and automation reminders in smartsheet with email and notification alerts, then send update requests to change task status, add comments or attachments, and monitor pending responses.
Card view and Board View comparison. Also known as Kanban view
Defining the timeline and column relationship for Predecessor, Start Date, End Date and duration
Describing the Parent and Child tasks.
Predecessor relationship, like Finish to Start, Start to Start, lead and lag and how to mention it
Gantt view or Gantt chart. How to access Critical Path, Baseline vs Variance all explained in details.
To explain further concepts of Forms, Workspaces etc workflow is explained as a Project.
How the workspaces works, how to share with others and mange the access level
How to make Form for capturing the request.
Describing Basics of Automatin and how to build from template or from scratch
We will learn how to use Copy the Row option in this lecture.
Automation on notifing contacts
Learn how to automate Smartsheet workflows by moving a row to a resolved sheet when status changes to resolved and the task is assigned, with testing and troubleshooting tips.
Learn to build a Smartsheet automation that sends update requests when a row is added, collecting time and quality feedback with star ratings.
Using refrnces for linking others sheet cells and Columns using Cross Refernce Sheet
Master column formulas in Smartsheet to compute percentage complete, forecast cost, and planned vs actual costs, using status checks and convert-to-column formulas.
Learn how to use index plus match in Smartsheet to retrieve engineer hourly or premium rates based on availability, handle department mismatches, and compute total project cost.
What you'll learn
Navigate and customize Smartsheet’s interface like a pro
Build smart, interactive project plans using sheets and Gantt charts
Set up automation rules to save time and eliminate manual work
Collaborate with team members using comments, forms, and sharing options
Create dynamic dashboards and reports for stakeholders and leadership
Manage project requests and approvals using forms and workflows
Use templates and control center approaches for repeatable processes
Apply real-life project scenarios from engineering, IT, and marketing
Course Description
Are you ready to master Smartsheet — the all-in-one platform trusted by Fortune 500 companies and fast-growing startups?
Whether you're a project manager, team lead, business analyst, or a complete beginner, this course will help you unlock the full potential of Smartsheet. Designed with real-world workflows and hands-on exercises, this course takes you from fundamentals to advanced automations and dashboards.
Inside, you’ll learn how to:
Build projects using Gantt, Kanban, and Calendar views
Create smart automation rules to simplify repetitive tasks
Use conditional formatting, data linking, and formulas
Design dashboards and reports that deliver insights at a glance
Set up a project request system with approval workflows
Apply Smartsheet in common business use cases like client onboarding, marketing tracking, and IT project delivery
By the end of this course, you’ll be equipped to manage your work more effectively, present data more clearly, and deliver projects more efficiently — all using Smartsheet.
Who this course is for
Beginners looking to learn Smartsheet from scratch
Project managers and coordinators who want to streamline processes
Operations or marketing professionals looking to organize work
Small business owners aiming to track projects and team progress
Anyone who wants to automate workflows and collaborate better