Smartsheet review: What are the top features and cost? – TechRepublic

Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below.
We recently updated our Terms and Conditions for TechRepublic Premium. By clicking continue, you agree to these updated terms.
Invalid email/username and password combination supplied.
An email has been sent to you with instructions on how to reset your password.
By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.
You will also receive a complimentary subscription to TechRepublic’s News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.
All fields are required. Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).
Smartsheet review: What are the top features and cost?
Your email has been sent
This is our hands-on tested review of Smartsheet. Learn about the pros and cons of Smartsheet’s features with our in-depth review.
Smartsheet is one of the leading project management platforms, and after reviewing the cloud-based software, I understand why. From onboarding to documentation, the Smartsheet platform offers robust features, workflows and automations for general project management needs.
While some project management platforms serve niche teams and industries, Smartsheet is a PM software for the masses. The interface will feel familiar to spreadsheet users, but Smartsheet adds capabilities that are difficult or impossible to build from scratch in Excel. The combination of the user-friendly tooling and hundreds of pre-built templates offered by this top PM vendor help project managers and team leaders to get their projects organized and moving quickly.
SEE: Feature comparison: Time tracking software and systems (TechRepublic Premium)
Jump to:
This review is based on my experience registering, configuring and executing a project in Smartsheet. The sample project I built in the tool is a three-month application development timeline with six sprints and over 20 core tasks.
Below is a look at the sample project (Figure A). The columns listed include task name, start and end dates, assigned contact, status, duration, completion percentage and notes. Meanwhile, rows organize sprint tasks and subtasks into sprints.
Figure A
To add additional context, I familiarized myself with Smartsheet’s product documentation, demos, industry reviews and recognition and a comparative analysis with alternative software applications. I ran a free trial of the Business plan to test this tool.
Smartsheet is a cloud-based project management software that helps teams of all sizes and varying degrees of technical skill to organize, visualize and communicate clearly about projects and tasks within a familiar, spreadsheet-style interface.
Founded in 2005, Smartsheet, Inc. released its project management software a year later with slow growth before a redesign in 2010. A decade later and the cloud-based platform has over 80,000 users in 190 countries.
Project managers and administrators alike can use Smartsheet to generate project objectives, workflows and reports to simplify scheduling, assign tasks and track progress. Through the mobile or desktop application, users can readily access the platform to communicate with team members or update a task’s completion status (Figure B).
Figure B
Through a SaaS subscription or free trial, users can start fast, create or import a project, and explore platform features.
From Smartsheet’s homepage, new users can watch a demo to get a feel for its capabilities, or they can try the platform by registering with an email address via the Try Smartsheet For Free button. Existing users working from a new browser or device can also log in through the buttons in the top right corner.
Users then need to verify their account with the confirmation link sent to the email address they provided. Once verified, they will be directed to Smartsheet’s main interface. New users can also download the iOS or Android companion applications for Smartsheet through the Apple or Google Play stores.
The Smartsheet platform’s features are designed around deadline-driven tasks and give project managers and business users space to collaborate in the context of each task.
Teams with existing project data can cut manual input and redundant work by importing project data through Microsoft Excel, Microsoft Project, Google Sheets or Trello (Figure C).
Figure C
This project was imported from a Google Sheets file. I only had to make minimal adjustments to properly align the data before exploring additional features (Figure D).
Figure D
Account administrators start their premium project management experience with a sheet. At a glance, sheets look much like a standard spreadsheet where users can import or capture data for central collaboration and management.
On the Smartsheet platform, columns represent project-specific data like dates, team members, dropdown lists and system data, while rows can group tasks and contain other media like conversations, links and file attachments (Figure E).
Figure E
Together, team members and project leads can configure columns and rows within one or multiple sheets to fit the team’s project parameters and planning needs.
The Primary Column is always on the far left, and it must be a valid text or number field and contain the central row or task name. Users can double-click on other columns to quickly create and format other conditions (Figure F).
Figure F
To the left of the Primary Column, users will see four small icons that also appear upon hovering over rows. These icons let users attach, comment and submit items to the task row for proofing or review.
Users can drag and drop rows to fall under sprints based on the needs of the task or the bandwidth of the team, which is useful for task reprioritization or the inevitable delays. For detailed projects with multiple parts within tasks, team members can right-click a row to access the indenting or outdenting options and move the task from parent to subtasks or vice versa.
In the Primary Column, users can collapse and expand parent tasks or an entire sprint containing a number of subtasks for more or less details when viewing the project (Figure G).
Figure G
In the above screenshot, the tasks included in “Sprint 1: Concept” are condensed to show what’s ahead. Meanwhile, the row contains a plus sign (+) in the Primary Column (Task Name) to allow users to expand sprint or parent task details.
For each sprint and parent tasks, as seen in row 22 for “Ongoing support and maintenance,” users can also condense items via the minus sign (–) corresponding to the row. As seen on the far left, multiple rows have comments and attachments and the sprint rows are locked.
As far as project management software is concerned, this interface is easy enough to use and organize tasks. However, this view is not going to be much easier to parse for quick insights than a standard spreadsheet.
With access to over 350 pre-built templates covering common workflows for professional services, retail, entertainment, construction and IT projects, Smartsheet customers can avoid duplicative work. All of the templates and template sets are available through the platform Solution Center.
Smartsheet includes three alternative layouts to visualize and review project data. This is where Smartsheet eclipses the usefulness of a standard spreadsheet: By transforming project data to Gantt, card and calendar views, project stakeholders have choices in how they view, organize and work through their tasks.
A key attraction to tools like Smartsheet is their ability to consolidate and visualize pertinent information related to project tasks, objectives and progress for a mix of user preferences. Smartsheet has the familiarity of traditional solutions with the power to enhance visualization and onboarding new users without mastering Excel formulas and spreadsheet conditions.
For each of the alternative views, users can double-click on an existing task to read or edit its contents. The in-browser window lets users edit existing task or subtask metadata, view attachments, create a proof or add a comment to the task (Figure H).
Figure H
Gantt charts are one of the most popular project management tools, offering a view of project tasks, deadlines and progress against a timescale. With at least two date columns representing start and end dates for tasks, and the ability to provide insight into what tasks rely on the completion of another, the Gantt View offers a clear view of project progress (Figure I).
Additional features within Gantt View include:
Figure I
With Card View, users have a board splitting all rows (tasks) into columns, also called lanes, based on a condition of the project manager’s choosing. The most common condition is task progress, where project leads and stakeholders quickly visualize the status of a task by moving it across columns with labels that indicate progress toward completion like Reviewed, Complete or In Progress. This is a format that is similar to kanban-style task management tools like Trello.
Users can view cards by Primary Column level, stakeholder assigned the task or task status. Card View is preset to see all levels of tasks and shows every row. However, users can also choose to see only the first, second or third level of tasks as configured in the core sheet.
In the top right corner the Card View, the user can configure how they see cards with a Compact View only showing the title, and a Full View showing additional task details (Figure J).
Figure J
By selecting a card, users can drag and drop tasks horizontally between different lanes as the task moves through different progress points or vertically within its lane to signify its deadline or priority.
In the above screenshot, readers can see tasks in the Not Started column include the extent of items in waiting. Notably, some of the Sprint 6: Retirement tasks like Project Analysis and Team Offboarding are up top when they should be out of view in the current timeline. A user can drag cards up and down its lane as best suits the team (Figure K).
Figure K
Users can view their project through a standard calendar that shows project tasks by their start date. Users can switch between one month and one week views to observe short-term and long-term tasks.
The Calendar View also lets users publish the project dates into an existing calendar account like Apple’s Calendar, Outlook and Google Calendar, or import a Google Calendar into the Smartsheet calendar.
While I didn’t use this feature, I can see where seeing critical project dates alongside existing work calendars would be incredibly helpful (Figure L).
Figure L
The Smartsheet platform enables collaboration between stakeholders consistently throughout its features with opportunities to assign tasks, notify stakeholders of changes and tag users. Project managers and team members can share sheets with internal and external stakeholders to delegate tasks and help others visualize the project details.
From any of the project views, users can expand a row’s details to see attached comments or conversations. Figure M shows all of the comments for the sheet on the right hand side and the row pertaining to the comment.
Figure M
In the top left corner of the dashboard, users can see three core buttons: File for file management, Automation for creating workflows and Forms to generate surveys for stakeholders (Figure N).
Figure N
The dropdown for the File button will feel familiar as it offers quick management features for the sheet and data, including:
To simplify frequent or critical workflows, the Automation button lets users create workflows from a pre-built template or scratch. Common workflow templates include sending notification and reminders, approving and updating requests, sheet changes and sheet-to-sheet workflows.
In the top right corner, users can view and manage existing workflows or create a new workflow from scratch by choosing a trigger, conditions for executing an action and alternative actions if the condition isn’t met (Figure O).
Figure O
An example of an available workflow template includes alerting someone when a row is deleted. In the above example, any time a row is deleted within a sheet the workflow creator can choose who to notify and through what medium (e.g. Slack, Microsoft Teams, email).
Figure P shows a workflow I made from scratch to notify stakeholders of task completion status on Fridays. If tasks are not complete, the workflow notifies the project manager.
Figure P
Administrators can control automation permissions to restrict who can receive notifications and requests with options of:
With Smartsheet, users can create forms with custom branding to share with colleagues, clients, contractors and other stakeholders. On the left hand side, users can optimize user experience by crafting the form with headers, dividers or a button for uploading files.
Users can set form fields to fit data collection needs by configuring fields on the right hand side including the field’s public label, help text, validation, multi-line boxes and whether the form field is required or hidden (Figure Q).
Figure Q
Through Form Settings, users have additional options for form layout (vertical, side-by-side or plain), security measures like requiring a Smartsheet login or CAPTCHA before access, post-submission behavior and emailing recipients of copy of form data.
All of these features help streamline essential data collection, customer and partner relationships, and communications by turning requests into tasks that the team can then add to their task backlog or prioritize as necessary.
The Smartsheet Control Center offers the most visibility and control over sheets, reports and dashboards to give system administrators a centralized view of activity and scale workflows. Administrators can manage the approval process for projects, replicate workflows and manage resource allocation. The Control Center also offers portfolio analytics, change management and automated provisioning.
With a mix of internal and external stakeholders, Dynamic View offers granular sharing permissions that automatically adjust according to the process lifecycle. Administrators can configure access and edit privileges for business process owners for a set time or task.
For enterprise organizations managing enterprise resource planning, customer relationship management, Lightweight Directory Access Protocol or data warehousing, Data Shuttle can consolidate critical business data into Smartsheet projects.
Smartsheet plans include three editions — Pro, Business and Enterprise — with monthly or annual subscription prices. Interested teams can use the company’s quote engine for evaluating costs of plans from one to 200 users.
Note: All enterprise plans require contacting the company for a quote, while Pro and Business editions require a quote request for plans over 25 users (Pro) and 50 users (Business).
Below is a look at how Pro and Business subscriptions compare.
The Pro plan is ideal for smaller teams, startups and businesses with up to 25 users and includes most of the core features needed to start planning and executing a project.
For companies seeking more enterprise-aided features, the Business plan has a minimum of three users and builds on Pro with up to 1TB in file storage, unlimited viewers and collaborators and security controls.
Finally, enterprise organizations managing multiple teams and remote offices or team members will be most at home with the Enterprise plan, offering the most in cybersecurity features, no-code development and administrative control.
Every plan comes with a stack of automation features:
The lone difference in automation capabilities is Business and Enterprise plans get unlimited automations while Pro clients have 250 per month.
Though Business and Enterprise editions offer the most in features, there are also a handful of additional features requiring an additional purchase for these customers.
All plans can add Brandfolder for digital asset management while Business and Enterprise clients have the most access to add-ons. Note: Standard Support comes with Enterprise plans and is available as an ad-on for Business clients.
With as universal as project management is, there’s no surprise Smartsheet’s clients are a broad swath of industries and roles.
The project management specialist’s extensive presence includes over 80% of the Fortune 500 and 90% of the Fortune 100 companies. Smartsheet’s clientele includes more than 83,000 brands across 190 countries boasting over 2,000 documented use cases to date.
The Smartsheet platform offers 78 different integrations to connect data and systems and reduce jumping between applications. Notable connectors include:
Premium add-on integrations include Salesforce, ServiceNow, and Smartsheet’s own tools: Calendar App, DataMesh, Dynamic View and Pivot.
Smartsheet offers four levels of technical support to help clients troubleshoot problems, mitigate risks, respond to emergencies and address the product life cycle.
All plans starting with Standard Support include options to contact Smartsheet 24×7 by phone or web chat. The Standard plan also comes with Smartsheet University eLearning.
The lone additional feature for Professional Support is access to a Pro Desk specialist, trained to work with clients to answer questions, guide effective usage, and manage governance and administration. Without diving into the company’s documentation, clients can cut to the chase with essential guidance on how a specific team or business can utilize workflows and processes.
The premium support plans start with a Technical Account Manager dedicated to addressing specific client needs. While Professional Support offers one-on-one sessions with Smartsheet personnel, the TAM is a designated individual with a service-level agreement to boot.
The TAM support tier offers established communication channels and scheduled meetings with a named contact available 24×7 for critical situation paging. The TAM plan also includes early access to features and proactive outreach for service impacting events.
Finally, TAM Enhanced bundles everything mentioned with a handful of additional features suited for enterprise-level customers. These features include active monitoring of critical sheets, solution lifecycle management, lightweight solution builds and a Control Center sandbox environment.
For clients and interested customers, Smartsheets offers a bundle of resources to enable a seamless onboarding experience and resolve pain points. These resources include the company’s stakeholders community, help and learning center, and eLearning via Smartsheet University.
Administrators and regular users can jump to the Smartsheet Community page for discussions and threads related to using the platform, integrations, APIs and best practices. The company’s Community also includes several industry or topic-specific groups including healthcare, construction, government and IT professionals.
The Smartsheet Help and Learning Center offers extensive documentation covering 147 topics via self-paced learning tracks. For a quick answer, troubleshooting or informational questions are a search away with additional filters for specific products, query type and language (Figure R).
Figure R
Through Smartsheet University, clients and interested users can watch onboarding videos, take instructor-led classes and get certified as a product expert. Smartsheet University offers two accreditation routes for certified associates: Core Product and System Administrator.
The Core Product certification covers general platform workflow management skills including sheets, collaboration, automation, formulas, forms, reports and dashboards. The System Administrator certification covers solution administration domains including managing license, users, groups, account settings, security policies and audit reports.
Certification exams cost $149 per attempt with virtual proctoring. Certified associates can renew their certification annually or earn Professional Development Units in lieu (Figure S).
Figure S
For organizations looking to minimize onboarding or outsource core Smartsheet processes, the company’s professional services lineup includes:
Smartsheet’s consulting delivery framework focuses on differentiating business strategy, maximizing impact, accelerating time to value, and continuous improvement.
SEE: Windows, Linux, and Mac commands everyone needs to know (free PDF) (TechRepublic)
The company’s partner program is Smartsheet Aligned, providing channel partners access to leads, deals, discounts and market development funds while offering clients Smartsheet platform capabilities. Businesses can login to the Smartsheet Partner Portal to train staff, access marketing materials, manage sales or work with a dedicated channel account manager.
Smartsheet currently has over 270 partners split between reseller, distribution and tiered partners. As the partnership grows, businesses can attain silver, gold and platinum partner tiers for additional incentives.
Companies interested in Smartsheet’s value-added services can complete the following partner application.
While other project management solutions speak directly to IT and software development teams, Smartsheet is a general project management solution offering teams of all departments and across industries a convenient platform to consolidate, edit and manage projects.
TechRepublic Enterprise Spotlight provides you with periodic updates about the newest IT-related products, services, and special offers from TechRepublic partners.
Smartsheet review: What are the top features and cost?
Your email has been sent
Your message has been sent
TechRepublic Premium content helps you solve your toughest IT issues and jump-start your career or next project.
Looking for the best payroll software for your small business? Check out our top picks for 2022 and read our in-depth analysis.
Next year, cybercriminals will be as busy as ever. Are IT departments ready?
Coursera offers a variety of training options for the growing data professional. Explore top data science courses from Coursera now.
Organize a number of different applicants using an ATS to cut down on the amount of unnecessary time spent finding the right candidate.
Whether you are a Microsoft Excel beginner or an advanced user, you’ll benefit from these step-by-step tutorials.
For SMBs, hiring a service to handle payroll calculation, processing and documentation can save valuable time and resources. This comparison chart with sample information provides a framework for comparing potential services. More on choosing a service: Payroll services The are several basic payroll services that all vendors should offer regardless of cost or additional services …
Employees who work from home often use company-supplied systems and devices, which helps ensure that they have consistent, state-of-the-art equipment to do their work. However, organizations should provide usage guidelines, such as this policy, covering the responsibilities of IT staff and employees. From the policy: For an organization to properly implement this policy it is …
Virtualization platforms are available from a number of vendors, but it’s still critical to maintain your virtualization environment to avoid unnecessary resource consumption, out of-compliance systems or applications, data loss, security breaches and other negative outcomes. This policy defines responsibilities for both end users and the IT department to ensure that the virtualized resources are …
For modern businesses, cloud platforms and the services they provide are often the most effective way to establish a competitive advantage. However, the jargon and numerous acronyms associated with cloud platform services tend to be confusing. This quick glossary of 25 common cloud platform terms will help you get a handle on the vocabulary. From …



Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top