June 22, 2023

How to Use Smartsheet for Project Management 2024

Written by
Why is TechnologyAdvice Free?
smartsheet

Smartsheet work collaboration and management software is an all-in-one project management SaaS (software-as-a-service) tool, a unique hybrid that combines the fine detail of working within an Excel or Google Sheets spreadsheet with the full-service support and luxury of a mature program like Microsoft Project.

But spreadsheet project management software can sometimes come with a learning curve. So let’s go over some of the basics to get you started.

Project management basics for using Smartsheet

To start, Smartsheet does have a free plan if you need to stick to a low budget, but you can get the most out of Smartsheet with a paid plan. Regardless of which option you choose, the software does start off with a quick initial checklist of items to help you get familiar with the system.

Also Watch: Smartsheet Review

And to help users further learn the ins and outs of the tool after that initial checklist, Smartsheet offers a Getting Started online guide, videos, help articles, and scheduled webinars. So there are plenty of resources to help you navigate the project management tool, but we’ll go through some of the high-level tasks so you can get some idea of how it works.

How to create sheets

Choosing a template

Save time by choosing a prebuilt template. This can always be modified once you’re more familiar with the software.

For example, you can choose a project timeline template (set up as a Gantt chart), which includes placeholders for task lists with statuses, start and end dates, and task assignments. Or you can start with a project board template, such as a kanban view of items laid out and identified as “not started,” “in progress,” “on hold,” or “complete.”

Collaborating on shared sheets

With Smartsheet, you can contribute to a sheet someone else on your team has shared with you or share your own sheet, report, template, or dashboard (or selective information) with your team or clients.

Smartsheet allows you to share sheets to an individual email address with a unique message or to a Smartsheet group. You can also send a sheet as a PDF or Excel file attachment or publish a public real-time link to share with people that do not have a Smartsheet account.

Once shared, you can choose from three different permission levels: viewer, editor, or admin. You can also share a workspace or individual sheets within a workspace.

Importing from another program

Rather than filling out your Smartsheet template from scratch, you can start with information from another source and build from there. Smartsheet currently supports imports from Microsoft Excel, Microsoft Project, Google Sheets, and Atlassian Trello.

Starting fresh

While templates are useful and can save time, some use cases can benefit from creating a sheet from scratch. To do so, start with a blank sheet and custom build the layout and functionality you desire.

Sheets, or grid views, are orientated in columns and rows like a spreadsheet with options on how to display data. Title columns with points of data or details you want to keep track of, then add your tasks and fill in those details.

For instance, you can assign work to individuals using “contact” columns, keep tasks on schedule using “date” columns, and summarize tasks using symbols and drop-downs. You can also rearrange or change columns to make tasks and details easier to navigate, and you can set up reports, dashboards, forms, and automation.

Rows capture all the details for one task, and you can attach related files and hold “conversations” with your team for a single task. Mess around with different view and filtering options to organize and group tasks in a way that works best for your processes. If you need to use a sheet you created for another project, save it as a template so you can start again without starting over.

Creating and assigning tasks in Smartsheet

Once you are set up in Smartsheet, either using a template, collaborating on a shared sheet, or creating one from scratch, you can add contacts and tasks.

Insert single or multiple task rows in a sheet by right-clicking on a row number and inserting a new blank row above or below. Copy and paste rows for repetitive tasks and group multiple tasks. Once your tasks are detailed out, you can assign a person or a group of people to a task from the contact list column.

When team members are assigned to tasks, you can track various team responsibilities more easily and automate notifications and reminders. You can also use the contact column to generate reports of tasks assigned to specific people.

Additional Smartsheet features to know

Collaboration

Basic and useful collaboration options in Smartsheet include:

  • Attaching relevant files for reference
  • Adding comments for others to pick up
  • Starting conversations on specific details and tasks as work evolves
  • Scheduling reminders for when things are due
  • Sharing project plans with the team, clients, and vendors via a simple link

Smartsheet views

You can set your work to be viewed and arranged in multiple ways and with different perspectives with the click of a button for efficient task management. There are four distinct views:

  • Grid View: This is a basic spreadsheet view with lines of information that can be sorted by set columns across the screen and detailed rows that can be grouped. Both columns and rows can be rearranged by dragging and dropping.
  • Gantt View: Visualize your project and the relationships between key tasks over time with a classic Gantt chart timeline view.
  • Card View: Easily visualize, prioritize, and organize work with drag-and-drop cards in a style that is familiar and useful to Scrum and kanban teams.
  • Calendar View: Highlight key dates, see the big picture, and track milestones in a classic calendar view that can be published to Google Calendar, Microsoft Outlook, or iCal.

Status reports

Stop spending endless amounts of time creating weekly status reports manually by collecting data that already exists somewhere else, tracking down people for further clarification, and scheduling additional meetings.

Simplify and automate the process with Smartsheet reports by pulling data from other sheets and setting it to automatically send out reports to relevant stakeholders on a regular schedule. This will allow you to enjoy more consistency and frequency of reporting, as well as improved data quality.

Screenshot of project management dashboard in Smartsheet

Dashboards

Create a master dashboard for executives to quickly show how work aligns to the strategic goals executives and stakeholders care about. Give them an overview of their business at a glance, along with a true health check and upcoming milestones.

Create a project management dashboard to stay on top of overall program status, drill down to individual projects and details, and quickly access related documents and links.

Keep everyone, no matter their role, updated with real-time information, so key people can adapt to changes and make educated, data-driven decisions.

Advanced features in Smartsheet

Smartsheet has developed many advanced features over the last few years, including filters, a resource management section, and Jira and Salesforce connectors.

They now offer Smartsheet University and a Core Product Certification exam that tests your knowledge of Smartsheet and validates your ability to build collaborative work environments.

They also send out a biweekly email blast to subscribers to share the Smartsheet formula of the week for those inclined to try their hand at coding and build in specific functionality.

A powerful SaaS solution, Smartsheet allows managers to minimize project status meetings while keeping everyone connected, informed, and engaged by tracking all work in detail and summarizing details visually in real time.

But if Smartsheet isn’t quite the solution you thought it’d be, there are several other options on the market—you can take a look at our top project management software to see what’s out there.

Related articles


1 monday.com

Visit website

monday.com Work OS is the project management software that helps you and your team plan, execute, and track projects and workflows in one collaborative space. Manage everything from simple to complex projects more efficiently with the help of visual boards, 200+ ready-made templates, clever no-code automations, and easy integrations. In addition, custom dashboards simplify reporting, so you can evaluate your progress and make data-driven decisions.

Learn more about monday.com

2 Quickbase

Visit website

Big ideas aren’t simple to execute. So we’re here to help you tackle any project, no matter how complex. We’re Quickbase.

Quickbase helps customers see, connect and control complex projects that reshape our world. Whether it’s raising a skyscraper or coordinating vaccine rollouts, the no-code software platform allows business users to custom fit solutions to the way they work – using information from across the systems they already have.

Learn more about Quickbase

3 Wrike

Visit website

Wrike’s top-notch workflow management software allows you to easily visualize priorities, boost collaboration, and maintain control of your projects. Bonus: you can move seamlessly between apps, without logging in or out. Wrike has more than 400+ integrations with popular platforms such as Google, Dropbox, Microsoft Office, and many more. Automation and AI features strip away time-consuming admin tasks so you can do the best work of your life.

Learn more about Wrike

TechnologyAdvice is able to offer our services for free because some vendors may pay us for web traffic or other sales opportunities. Our mission is to help technology buyers make better purchasing decisions, so we provide you with information for all vendors — even those that don't pay us.
In this article...