We may earn an affiliate commission when you visit our partners.
Course image
Justin A Orazio

You will learn how to create forms in Smartsheet and then manage the data that comes in by creating automations, workflows, Reminders, and conditional formatting. You will even learn how to turn your form into a QR code so anyone can scan and fill. I will guide you step by step in how to create the form the right way so that the data that comes in is formatted the way you desire it. You will learn how to automate workflows so that when new data comes in, from the new form submissions, nothing will be missed and everyone who you choose will be notified. You will also learn how to use the row actions to your advantage so that reminders are set in place and pictures and documents can be reviewed by the team. Within automations you will also learn how to set up workflows that allow your team to approve or deny a submission that is specifically sent to them. When you are done completing this course you will be confident in building out forms from scratch for your company. With a strong foundation in creating forms you will be building a strong base for the rest of your project management within Smartsheet.

Enroll now

Here's a deal for you

Save money when you learn with a deal that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

What's inside

Learning objectives

  • Confidently navigate your way around on smartsheet from top to bottom
  • Create task lists for your teams
  • Learn how to easily transfer mass excel data into smartsheet automatically.
  • Create and manage workflows for your business through smartsheet
  • Create automations through smartsheet to streamline your workflows
  • Create and manage gnatt charts
  • Create forms to caputure responses and data from anyone
  • Create qr codes that can take anyone to the form you just created
  • Create metric sheets that capure the data from forms
  • Create formulas confidently on the same sheet
  • Create formulas confidently that cross over multiple sheets
  • Create dashboards that are professional, clean, and have clarity
  • Create dashboards that gather data from metric sheets that consolidate the info in a clean clear way to understand
  • Create automation within sheets to streamline work you and others
  • Create forms that capture specific responses that automatically get put on your custom pdf
  • Learn how to make pos (purchase orders) and forms that request pos.
  • Create and manage reports
  • Learn how to cell link between sheets.
  • Show more
  • Show less

Syllabus

You learn how to create Forms in Smartsheet, and then take that data that comes in and manage it however you would like with automations, workflows, etc.
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Teaches Smartsheet, which is a leading platform for project management, workflow automation, and collaborative work management, making it highly relevant for professionals in these fields
Develops skills in creating forms, automating workflows, and managing data, which are essential for streamlining business processes and improving team collaboration
Explores the creation of QR codes linked to forms, which can be a creative approach to data collection and accessibility for a wide range of users and devices
Focuses on a specific software, Smartsheet, so learners should ensure that this software aligns with their current tech stack and organizational needs before enrolling
Requires access to Smartsheet, which may involve a subscription or licensing fee, potentially posing a barrier for some learners without institutional access

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Practical smartsheet workflow management

According to learners, this course provides practical skills for managing workloads and streamlining processes using Smartsheet. Students praise the clear, step-by-step guidance provided by the instructor, which helps them effectively learn how to create forms, build automations, and develop useful dashboards and reports. Many found they could immediately apply the techniques learned to their work, making it a highly recommended resource for professionals. While offering a solid foundation in core features, a few reviewers noted that some more advanced topics could receive greater depth.
Great start, some desire more depth.
"A good introduction to Smartsheet workflows. Covers the basics... though they could have gone into a bit more depth."
"Some of the more advanced automation logic wasn't covered in detail, which would have been helpful. Still, a great starting point."
"Useful course for getting started with Smartsheet forms and basic automations."
"Gives a solid introduction to Smartsheet workflows."
Focuses on forms, automations, dashboards.
"This course was exactly what I needed to get a handle on Smartsheet forms and automations."
"Learned how to use conditional formatting effectively and build dashboards..."
"Covers the basics of forms, automations, and reports well."
"Loved this course! ...confidently building forms and automating tasks. The QR code part was a nice bonus."
Easy-to-follow guidance on features.
"The step-by-step guidance was clear and easy to follow."
"Fantastic course! The instructor explains everything clearly."
"The instructor paced it well and provided great examples."
"Useful course for getting started... The explanations are clear."
Instantly use skills for your work.
"I was able to immediately implement what I learned into my daily workflow."
"Learned how to use conditional formatting effectively and build dashboards that actually make sense. The practical examples made it easy to apply to my own projects."
"Very practical and focused on real-world application."
"Excellent course for practical Smartsheet usage. Focused on forms, automations, and reports which are critical for my job... Highly applicable."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Workflow My Workload with these activities:
Review Smartsheet Fundamentals
Reinforce your understanding of Smartsheet basics to ensure a smooth learning experience in creating forms and workflows.
Browse courses on Spreadsheet Software
Show steps
  • Review Smartsheet's interface and core functionalities.
  • Practice creating basic sheets and using formulas.
  • Familiarize yourself with different view options (Grid, Gantt, Calendar).
Review 'Smarter Spreadsheet Skills: Microsoft Excel'
Gain a deeper understanding of spreadsheet principles, which are transferable to Smartsheet, enhancing your ability to create effective forms and workflows.
Show steps
  • Read the chapters on formulas and data validation.
  • Practice applying the concepts learned in Excel to Smartsheet.
Document Your Workflow Process
Solidify your understanding of workflow creation by documenting the steps involved in a specific process you want to automate using Smartsheet.
Show steps
  • Choose a real-world workflow you want to document.
  • Outline each step in the workflow, including inputs, actions, and outputs.
  • Identify opportunities for automation using Smartsheet forms and workflows.
  • Create a visual representation of the workflow (e.g., flowchart).
Four other activities
Expand to see all activities and additional details
Show all seven activities
Form Creation Practice
Reinforce your form creation skills by repeatedly creating different types of forms with varying data validation rules and conditional logic.
Show steps
  • Create a form for collecting customer feedback.
  • Create a form for submitting purchase requests.
  • Create a form for tracking project tasks.
Automate a Purchase Order System
Apply your knowledge by building a complete purchase order system in Smartsheet, including form submission, approval workflows, and data tracking.
Show steps
  • Design a form for submitting purchase order requests.
  • Create an automated workflow for routing requests to approvers.
  • Set up a sheet to track the status of each purchase order.
  • Create a dashboard to visualize key metrics (e.g., total spend, approval times).
Build a Project Management Dashboard
Demonstrate your mastery of Smartsheet by creating a comprehensive project management dashboard that visualizes key project metrics and provides real-time insights.
Show steps
  • Identify the key metrics you want to track (e.g., task completion, budget, risks).
  • Create metric sheets to collect and aggregate the data.
  • Design a visually appealing and informative dashboard layout.
  • Add charts, reports, and key performance indicators (KPIs) to the dashboard.
Help Others on Smartsheet Forums
Reinforce your knowledge by helping other users on Smartsheet forums with questions related to form creation, workflows, and data management.
Show steps
  • Find a Smartsheet forum or online community.
  • Browse the forum for questions related to the course topics.
  • Provide helpful and accurate answers to other users' questions.

Career center

Learners who complete Workflow My Workload will develop knowledge and skills that may be useful to these careers:
Forms Designer
Forms Designers specialize in creating effective and user-friendly forms for data collection. This course provides direct training in creating forms in Smartsheet, designing QR codes for form access, and customizing the forms for specific data capture needs. The lesson on forms in Smartsheet is obviously relevant for a Forms Designer. A course like this would equip a Forms Designer with the skills to create forms that automatically populate custom PDFs and streamline data collection processes.
Automation Consultant
Automation Consultants advise businesses on how to automate processes to improve efficiency and reduce costs. This course directly aligns with the role as it focuses on creating forms, automating workflows, and managing the resulting data. The course's focus on how to automate workflows and its strong foundation in form creation will be especially helpful. Completing this course would help you provide informed recommendations to clients on how Smartsheet can automate their workflows and improve their business operations.
Workflow Automation Specialist
The Workflow Automation Specialist focuses on designing and implementing automated processes to improve efficiency. This course will help you learn how to create forms, automate workflows, and manage associated data, all vital for workflow design. This course teaches how to build forms from scratch and automate workflows, providing a solid foundation for automating business processes. Because of the course's focus on creating automated workflows, anyone seeking to be a Workflow Automation Specialist should certainly take this course.
Data Manager
Data Managers oversee the collection, storage, and management of data within an organization. This course is relevant because it teaches how to create forms for data capture, manage data through automations and workflows, and ensure data is formatted correctly. The course teaches you how to manage the data in your spreadsheets. By learning to automate data workflows and manage data effectively, you, as a Data Manager, can enhance your organization's data management processes and efficiency.
Project Coordinator
Project Coordinators oversee project tasks, ensuring they are completed on time and within budget. Using Smartsheet, they can organize workflows and track progress. The course's focus on creating forms, automating workflows, and managing data will help you as Project Coordinator to build a strong foundation for project management within Smartsheet. Skills such as creating Gantt charts and dashboards would be helpful. This course will enable you to collect data, create automated notifications, set reminders, and manage approvals effectively, all of which are valuable for project coordination.
Business Intelligence Analyst
A Business Intelligence Analyst analyzes data to identify trends and insights that can help a company make better business decisions. This course will help you learn how to create forms in Smartsheet to capture data and automate its collection, which is vital for a Business Intelligence Analyst. This course also teaches you how to create metric sheets and dashboards to present data in a clear and understandable way. By learning to streamline data collection and create insightful dashboards, you will be equipped to support data-driven decision-making within your organization.
Project Assistant
Project Assistants support project managers by handling administrative tasks and ensuring projects run smoothly. This course is valuable for a Project Assistant because it teaches how to create forms, automate workflows, and manage data, all vital for project management. The course helps build a strong foundation for project management within Smartsheet and skills like creating Gantt charts can be very helpful. By learning to collect data, automate notifications, set reminders, and manage approvals effectively, a Project Assistant can better support project managers and improve project outcomes.
Process Improvement Coordinator
A Process Improvement Coordinator identifies and implements strategies to enhance operational efficiency within an organization. This course will help you learn how to create forms in Smartsheet and manage data effectively, which is crucial for a Process Improvement Coordinator who needs to collect and analyze information. The course teaches how to create automated workflows, which is a great skill to have in this role. By learning to streamline workflows and manage data, you will be equipped to design more efficient and effective business operations.
Business Process Analyst
A Business Process Analyst examines and improves business operations, looking for inefficiencies and areas for automation. This course will help you learn how to create forms in Smartsheet and manage data effectively, which is crucial for a Business Process Analyst who needs to collect and analyze information. This course can help you create automated workflows and manage data within spreadsheets, skills directly applicable to streamlining business processes. By learning to create forms, automate workflows, and manage data, you will be equipped to design more efficient and effective business operations.
Office Manager
An Office Manager is responsible for organizing and coordinating office operations and procedures to ensure organizational effectiveness and efficiency. This course will help an Office Manager by teaching them how to use Smartsheet to create forms, automate workflows, and manage data effectively. The course provides a strong foundation in form creation and workflow automation, which are essential for managing office tasks. The course objective of creation and management of workflows for business is directly aligned with this role.
Data Entry Clerk
Data Entry Clerks input and manage data, ensuring accuracy and organization. This course will help you learn how to create forms in Smartsheet, capture data efficiently, and manage it through automations and workflows. The course enhances skills in managing data within spreadsheets and creating forms to capture specific responses. By learning to automate data input and streamline data collection processes, a Data Entry Clerk can significantly improve their efficiency and accuracy, making their work faster and more effective.
Data Entry Specialist
Data Entry Specialists input and manage data, ensuring accuracy and efficiency. This course is directly relevant as it teaches how to create forms in Smartsheet, capture data, and manage it through automations and workflows. The course's lesson on managing data in spreadsheets is directly applicable. By learning to create forms that capture specific responses and automate data input, a Data Entry Specialist can enhance their efficiency and accuracy in data management, ultimately streamlining data processes.
Reporting Analyst
A Reporting Analyst is responsible for generating reports that provide insights into business performance. This course may be useful when it comes to creating forms to capture necessary information and automate the collection of data for reports. The topics of reports and metrics, in the course learning objectives, are aligned with the role of a Reporting Analyst. The course provides a practical approach to streamlining workflows and generating reports from captured data.
Database Administrator
Database Administrators manage and maintain databases, ensuring data is accessible, accurate, and secure. This course may be useful because it teaches how to create forms for data capture and manage data through automations. This course also teaches how to manage data in spreadsheets. By learning to streamline data collection and manage data effectively within Smartsheet, a Database Administrator may find this course helpful for integrating data from various sources into a database.
System Administrator
System Administrators manage an organization's computer systems, ensuring they run smoothly and efficiently. This course may be useful because it teaches how to create forms for data capture and manage data through automations. The topic of creating automations through Smartsheet to streamline workflows is aligned with the role of a System Administrator. By learning to streamline data collection and manage data effectively within Smartsheet, a System Administrator may find this course helpful for integrating data from various sources into a system.

Reading list

We've selected 50 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Workflow My Workload.
Offers a comprehensive overview of Business Process Management (BPM), which is foundational to workflow automation. It covers essential concepts, methods, and techniques suitable for both beginners and advanced students. It is widely considered a standard textbook in academic settings.
Seminal work on the subject of data visualization, and it is still one of the most influential books in the field. Tufte provides a comprehensive overview of the principles of data visualization, and he covers a wide range of topics, from data types to visual perception. Tufte's work is deeply rooted in using data visualization to present only truth and avoid misrepresenting data. This book is very thorough and can be challenging for those who are new to dashboards.
This comprehensive guide provides an in-depth overview of Smartsheet, covering its core features, functionality, and best practices for project management. It is an excellent resource for individuals seeking a thorough understanding of the platform.
Explores the fundamental trade-offs and concepts behind designing modern data systems, covering various technologies and distributed systems principles. It is highly relevant for understanding contemporary data management challenges and must-read for engineers and architects.
Delves into the contemporary topic of Intelligent Automation and Hyperautomation, exploring the combination of RPA, AI, and other technologies. It provides a forward-looking perspective on the future of automation and its impact on businesses and society. It is essential for understanding the current trends in the field.
Definitive work on the principles and techniques of transaction processing, a core concept in database systems and distributed computing. It is essential for understanding how to build reliable and consistent data systems.
This hands-on guide provides practical methods for project planning, scheduling, and control. It emphasizes delivering projects on time and within budget, with detailed coverage of scheduling tools and techniques, including Gantt charts. It's a valuable resource for professionals seeking practical application and mastery.
Focusing on the practical aspects of implementing BPM, this book provides real-world examples and guidance for successful projects. It valuable resource for practitioners looking to apply BPM principles to workflow automation initiatives. It complements theoretical knowledge with actionable strategies.
A concise and practical guide to building robust and user-friendly forms, emphasizing accessibility, usability, and performance.
Comprehensive guide to data visualization, covering everything from basic principles to advanced techniques. It is written in a clear and concise style, and it is packed with examples and exercises. This book does a fantastic job of providing a more in-depth look at many of the core principles associated with dashboards and great jumping-off point for learning more about them.
This widely-regarded book offers a detailed exploration of project management from a systems perspective, with significant coverage of planning, scheduling, and control techniques, including Gantt charts and critical path method. It comprehensive resource for deepening understanding and is frequently used as a textbook in university programs and by professionals.
Classic in the field of data visualization, and it is still one of the most influential books in the field. Tufte provides a comprehensive overview of the principles of data visualization, and he covers a wide range of topics, from data types to visual perception. Edward Tufte is one of the most celebrated authorities in the field of data visualization.
Provides a detailed look inside the implementation of database systems, covering topics like storage engines, indexing, and concurrency control. It is excellent for deepening understanding of how databases function at a low level and is valuable for database professionals.
Covers the end-to-end process of designing, building, and managing data pipelines and analytical systems. It is highly relevant for aspiring and practicing data engineers, covering a wide range of contemporary data management tools and techniques.
This practice standard from PMI offers guidance on developing and maintaining project schedules. It provides a detailed look at scheduling processes and techniques that underpin the creation and use of Gantt charts. It valuable reference for project managers looking to deepen their understanding of scheduling best practices.
An updated version of the beginner's guide, this edition aligns with the latest PMI standards, ensuring the information on tools like Gantt charts is current within that framework. It's an excellent starting point for anyone new to project management and preparing for certifications.
Explores the evolution of RPA to include cognitive automation, highlighting real-world implementations and the risks and benefits involved. It provides a deeper understanding of the advanced forms of automation and their impact on enterprises. It's a good resource for those looking beyond basic RPA.
Provides a practical guide to establishing and implementing data governance programs. It is crucial for understanding the organizational and process aspects of managing data effectively and valuable resource for data leaders and practitioners.
An excellent resource for those new to project management, this book covers the project lifecycle and key tools like Gantt charts in an easy-to-understand format. It's particularly helpful for high school and undergraduate students or professionals transitioning into project management roles, providing foundational knowledge for using Gantt charts effectively.
A widely-used textbook in database courses, this book offers a thorough introduction to database systems, including relational models, SQL, and transaction management. It's valuable for both broad understanding and deepening knowledge, providing a solid theoretical and practical basis for data management.
Focuses specifically on project scheduling techniques, offering a deeper dive into the methodologies that underpin Gantt charts and other scheduling tools. It's valuable for those who want to specialize in scheduling and gain a more profound understanding of the subject, suitable for graduate students and professionals.
Focuses on leveraging process automation technology, including workflow engines, to orchestrate various components like software, humans, and bots. It provides practical advice and explores how process automation fits into modern IT architectures. It is suitable for developers and architects.
Explores both traditional and agile approaches to project management, providing a contemporary view on how tools like Gantt charts fit into different methodologies. It's valuable for understanding how Gantt charts are used in modern project environments and is suitable for undergraduate and graduate students as well as working professionals.
Focuses on practical data engineering using modern technologies like Apache Spark and Delta Lake. It is highly relevant for professionals building data pipelines and managing data in cloud-based data lakes, addressing contemporary challenges in big data.
This guide provides practical advice and techniques for improving data quality, a fundamental aspect of effective data management. It valuable resource for anyone responsible for ensuring the accuracy and reliability of data.
Focuses on the principles and practices for building and operating reliable and resilient database systems. It is highly relevant for professionals in site reliability engineering and database administration, addressing the operational challenges of data management.
Offers a modern and comprehensive look at project planning and scheduling techniques, including those related to Gantt charts like Critical Path Method and Precedence Diagramming Method. It's a good resource for gaining a solid understanding of scheduling fundamentals and is suitable for new project managers and students.
Offers a practical approach to project management, illustrating concepts with real-world examples and case studies. It covers scheduling techniques and the use of Gantt charts in a practical context, making it highly relevant for both students and practicing professionals.
This textbook covers the entire project management process, including detailed sections on planning and scheduling where Gantt charts are discussed. It provides a strong theoretical foundation and practical examples, making it suitable for undergraduate and graduate programs.
Collection of essays on data visualization, written by one of the leading experts in the field. Yau covers a wide range of topics, from the history of data visualization to the latest trends in the field. This book provides a lot of real-world examples of dashboards and how they are used.
This playbook focuses on leveraging Microsoft's Power Platform, including Power Automate, for digital transformation and automation. It is highly relevant given the mention of Power Automate courses. It provides guidance on using a specific popular automation platform.
Examines the ethical considerations surrounding data and analytics, including privacy, bias, and accountability. It crucial read for anyone working with data to understand the societal impact and ethical responsibilities in data management.
Delves into various project management approaches, including traditional methods where Gantt charts are prevalent. It helps in understanding the context and application of Gantt charts within different project complexities and environments. It's a good resource for deepening understanding and is relevant for professionals.
Provides a practical guide to building and managing data pipelines using Apache Airflow, a popular workflow orchestration tool. It is relevant for data engineers and anyone involved in building automated data processing workflows.
Highlights common mistakes and poor practices in SQL programming and database design. It is highly practical for anyone writing SQL queries or designing databases, helping to improve efficiency and avoid common issues.
This guide provides a comprehensive look at BPM, covering frameworks and methodologies for implementing process improvements. It useful resource for anyone involved in managing and optimizing business processes, which is directly applicable to workflow automation projects. It offers practical guidance for practitioners.
Offers a comprehensive guide to project management planning and control, aligning with various industry standards. It covers scheduling techniques relevant to Gantt charts and useful reference for professionals, particularly in engineering, construction, and manufacturing.
Practical guide to designing effective dashboards. Few provides a step-by-step process for creating dashboards, and he covers a wide range of topics, from data selection to visual design. This is another book by Stephen Few that is very specific to the design of dashboards and how to create useful ones.
Foundational text in workflow modeling, providing tools and techniques for analyzing and improving business processes. While published some time ago, the principles of workflow modeling remain highly relevant for designing effective automation solutions. It's a valuable reference for understanding process design.
A comprehensive guide to web accessibility, including a chapter on building accessible forms, covering topics such as alternative text, keyboard navigation, and color contrast.
While focused on construction, this book provides a detailed look at scheduling techniques, including Gantt charts and critical path method, with practical examples and case studies. It's particularly useful for those in construction or related fields but offers valuable insights into scheduling for any complex project, suitable for upper-level undergraduates and professionals.
Provides a practical, hands-on approach to workflow automation using Zapier, a popular no-code tool. It is ideal for beginners and those looking to automate tasks without extensive coding knowledge. It offers step-by-step guidance and real-world examples.
This collection of seminal papers provides insights into the historical development and key concepts in database systems research. It is valuable for advanced students and researchers seeking to understand the evolution of data management ideas.
Designed to accompany Kerzner's main textbook or be used independently, this workbook provides exercises and study materials related to project management topics, including scheduling and Gantt charts. It's a valuable tool for solidifying understanding and preparing for certifications.
Aimed at individuals who manage projects as part of their role but do not have 'project manager' as their primary title, this book provides practical guidance on project management essentials, including scheduling and using tools like Gantt charts. It's a good resource for professionals across various disciplines who need to incorporate project management into their work.
Focuses on the strategic aspects of project management and how planning tools contribute to successful project execution. While not solely focused on Gantt charts, it provides context for their importance in achieving strategic goals. It's relevant for professionals and those in leadership roles.
Comprehensive guide to SAP Build Process Automation, a low-code/no-code platform. It covers creating and managing business process projects within the SAP ecosystem. It valuable resource for those working with or interested in SAP's automation tools.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Workflow My Workload.
Microsoft 365 Copilot: Harness AI for Data Management
Most relevant
Teradata: Improving Analysis and Storage
Most relevant
Zapier Mastery 2025: Automate Your Workflows & Save Hours
Most relevant
The Airtable Academy | Become a Pro with Airtable & Zapier
Most relevant
Asana -Project Management -The Complete Course for...
Most relevant
Mapping and Spatial Analysis of Crime- Open Software...
Most relevant
Using the Sheet Summary in Smartsheet
Most relevant
Smartsheet Basics
Most relevant
Smartsheet for Project Management - Earn 3.25 PDUs!
Most relevant

Udemy Buyer Protection & Guarantee

Verified partner policies & purchase protections

Global Marketplace Leader
Free Trial & Audit

Free Lecture Previews

Free preview video lectures available for all courses; optional 7-day free trial on Personal Plan subscriptions (cancel before trial ends to avoid conversion).

Return & Refund Policy

30-Day Money-Back Guarantee

30-day money-back guarantee on all eligible individual course purchases (provided course content has not been substantially consumed or downloaded). Subscription fees are non-refundable once billed.

Buyer Protections

Verified Academic & Industry Partner

Lifetime access to purchased individual courses and future updates, verifiable certificate of completion, and direct student Q&A forums.

Key Purchase Protections
30-day 100% money-back guarantee on course purchases
Lifetime access on web, mobile, and offline
Certificate of completion included with purchase
Direct instructor Q&A and active student community
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser