Reviews (1-25 of 66)
- It allows for attachments and notes at the row level; this keeps many of our documents organized and viewable on the mobile app and for all those who have rights to see the sheet.
- The automated approval process has cut down on manpower by 10%. This has resulted in increased productivity by eliminating repetitive but necessary steps.
- Reporting - this allows the roll-up of information that reaches across multiple Smartsheets. Important information can be realized at a glance rather than looking at many spreadsheets. It also allows for the sharing of only necessary information to stake holders.
- The mobile app has given me freedom to access the sheets at any time without having to store documents and information in multiple platforms.
- It would be helpful when importing an Excel spreadsheet if the format would remain the same; such as the color of the rows and columns.
- Sometimes when viewing rows on the mobile app, they don't align properly when scrolling across.
- I would like to see more in-depth training videos.
Several departments are utilizing Smartsheet within the organization. We are fairly decentralized with several hundred locations making collaboration difficult at times. Smartsheet made project coordination much easier.
I use Smartsheet primarily with my team for many different activities. We track and share time off & out of office information, track and share information on projects, as well as track team member tasks/processes/procedures, to organize and share knowledge documents, and for notices and collaboration across other HR groups.
- Collaboration. Smartsheet makes it very easy to share information with multiple users at the same time. It also has great functionality for sharing with non-users with great options for read-only or allowing those outside users to even edit sheets.
- Project management. Smartsheet has all of the functionality that Microsoft Project does, but is much easier to use. You can import and export Excel, Project, or a few other formats, and the system has multiple options for entering information. Different types of views can be deployed or updated easily.
- Reporting from Smartsheet is very easy. You can take data from multiple different sheets and combine them into one report. Depending on the user access you can also edit information from a report to update the original Smartsheets.
- Gantt Charts: While the functionality here is very good, sometimes there could be some better options with the automatic coloration of these charts. Additionally, exporting is a little limited.
- Formulas: There are a lot of basic formula options but there could be more. Additionally, calculations across multiple sheets could also be improved.
- Pivot tables: These are only available as an additional add-on app. I wish this functionality would be standard.
It supports our project leadership, management, organization and resource management
- For login purposes, we love that Smartsheet integrates with our university's existing login credentials.
- Smartsheet allows users to attach files to cells within a sheet. We have not seen this with similar products.
- The "Email Shared Users" feature is very convenient for notifying all interested parties of updates.
- The visual appearance of Smartsheet seems a bit outdated compared to products like Google Sheets.
- Depending on how a link to a sheet is sent to users, it sometimes takes a series of clicks to figure out how to log in with your company's credentials.
- It appears that Smartsheet does not accommodate the use of functions/equations within a sheet to the same level of complexity as Google Sheets.
A scenario in which Smartsheet is less appropriate is for assigning corresponding tickets or tasks that accompany a timeline or milestone.
- Easy to use and intuitive
- Sleek, clean user interface
- Manages user groups, security, and permissions with ease
- Parent / Child relationships at the 'sub-task' level could be easier to use. Sometimes i have issues 'rolling-up' data / numbers when I get below one level or two of sub-tasks. However it may just be user-error, as I have not had the time to investigate further or reference user manuals or tutorials.
- Nothing else. Smartsheet works quite well and does not leave much to be desired.
Smartsheets is well suited for collaboration. Multiple users, if given admin or editor privileges have the ability to make changes at once, avoiding issues that often can materialize regarding versioning errors typical, as a result of multiple authors or editors.
For project managers, smartsheets has multiple 'views' available, which can come in handy depending on your specific purpose. For those interested in seeing all of the details, the standard view is a table/spreadsheet type of view. For a more agile approach, or a simplified user view, their 'task-list' type view can help to easily view in a card-type of format and classify those tasks that have been 'completed' versus 'in-progress' , 'in qa' or other relevant category / classification. Other views include the Gannt chart view, which is helpful for seeing things in a calendar-like view, helpful in showcasing things like dependencies.
- The Form is a great feature. It allows sheet managers to create a simple user interface for capturing data from other users that you may not want to have access to the full sheet. It's also just a simple way for inputting data without distractions if the sheet is complex. I have used the form myself many times where it was the least distracting method to input data for many rows.
- Smartsheet's pre-built templates make a great starting point for many different applications of the tool. I have used the project management template many times and it makes setup of simple to complex projects with goals and timelines much easier, allowing easy flipping between sheet view, Gantt view or calendar view to track project tasks and milestones.
- Frequent improvements, with easy-to-follow notifications highlighting the improvements! It's great to see a product that gets regular updates to improve functionality and user experience. Even better when a company includes simple, helpful communications about those updates. I think Smartsheet does a great job of both. I regularly see a tutorial popup when logging into Smartsheet to highlight some new features, which is easily dismissed if I want to check it out later.
- Version control could use improvement. I'm not sure if this is a feature included in a higher level license than mine, but currently the only way I can find to track changes is cell history. If there are major rollbacks needed on the sheet, it can be tedious to do this by individual cells, which I have had to do. Still better than no version control though.
- A bulk sharing option would be nice. Currently, it seems the only option to share is by searching users and adding one by one. There's an option to create a group and share with the group, but adding users to the group is the same issue: one by one. A list import option would be ideal, especially since you can import sheets for use within the product. I would like to import a group by using a sheet of email addresses. If that feature exists I cannot find it in the product or product documentation.
- The Smartsheet interface is very user friendly and organized.
- The Smartsheet website is very fast and can be accessed from anywhere.
- It is so easy and quick to share files with anyone anywhere in the world with Smartsheet.
- I wish there was an autosave feature. It is very frustrating when there is an interruption in your connection and data gets lost.
- You cannot view changes in real time like you can with some other similar programs. You have to refresh to see changes made by others.
- The site is often under maintenance.
Review: "Excel on steroids! If you manage a team that manages a ton of projects, Smartsheet is a LIFESAVER! It's familiar, dynamic, and comprehensive in its reporting and dashboard features."
- Dashboards. If you know how to use them, they can combine the info and data from multiple sheets into one comprehensive view. This is crucial if you are managing a team that manages multiple projects in Smartsheet. It's like having all of the up to date, real time info at my fingertips.
- Love that they went mobile. I can check info onsite when I'm traveling without having to login to my computer or have my computer with me.
- I would love to see the ability customize some of the forms with our own branding.
- I would love the ability to be able to delete a sheet, even if I was not the owner. Perhaps maybe give an overall administrator status. We have folks who have left the company and I cannot delete their old sheets. It gets very cluttered.
- Organizing and editing of items
- Aggregated reporting of disparate sheet
- Many structured categories
- Flexible templates for many use cases
- Better linking between Smartsheets
- Integration with Google Forms where submissions can go straight to a Smartsheet.
- Allow for card creation at all levels (when view is changed from grid mode that has nested rows)
- The thing that made Smartsheet stand out to us from other project management solutions was how easy it is to use. The spreadsheet-like layout allows users to jump in and use it without much, if any, training. Once you are comfortable with the basic spreadsheet functions, you can dive into formulas and different layout options to make it as complex as you like.
- Alerts and Notifications help keep you aware of changes made or when certain tasks are due. It's easy to end up with a multitude of sheets and lose track of where you stand or what is due. With the variety of ways that you can set up notifications and alerts, Smartsheet does the work for you.
- I would love to see new features rolled out a little more quickly. Many users have been waiting for some time for the ability to multi-select items in a list.
- Conditional formatting makes it easy for anyone to personalize a sheet!
- Sharing sheets with free users, and they really have a considerable amount of usability!
- The scheduling aspect combined with many of the traditional Excel functions.
- Some of the automated update requests could use some tweaking. It would be nice to be able to send an automated request update to a contact list without a trigger.
- It seems as though there are a lot of requested functions that are not addressed.
- The sheet limitations seem a little low considering the package we are paying for.
- Generation reports - this is super simple to do and saves tons of time and effort. Instead of having to create reports every time you need one, we can generate a report any time and it is nearly instant.
- Linking sheets - this saves us from duplication of efforts. We will never have to input the same data into two separate sheets, instead we can update one sheet and it will populate into the linked sheets.
- Exporting documents - It is super simple to export documents into excel format so that they can be sent outside of our organization. It allows us to control what is internal, and what is shared externally.
- I preferred the old design better, but am slowly getting used to the new design.
- Being able to utilize and connect several people and teams to efficiently have a project flow
- Organized and easy to use
- Fast-working and adaptable when updated
- I sometimes have a problem linking sheets. This comes and goes, but is a hassle
- I'd love to see a easy to use calender sheet that could be shared
- Smartsheet is very good at tracking tasks and generating dependencies. The user interface for accomplishing these functions is very intuitive, especially for anyone who has familiarity with Microsoft Excel. It basically takes some of the functionality of Microsoft Excel and Microsoft Project and merges them into an application that is more user friendly.
- Smartsheet is also very good at offering connectivity and collaboration. Because of the way in which non-project management users can log in, receive notifications, and interact with the Smartsheet, it doesn't feel like it is the project manager's domain but rather something that is a tool for everyone to make use of and share.
- Smartsheet is very accessible. As a someone who used Microsoft Project in the past, it has been much more convenient to access Smartsheet through the web rather than having to ensure I have access to the latest file or ensure that multiple people aren't trying to work on the file at the same time.
- There really isn't much up-front guidance offered on using Smartsheet. As with any company, they will provide training and obviously have a help menu, but it would be nice for there to be some "forced" tips and tricks or tutorials provided to give new users the ability to "power-use" the software more quickly.
- Project files become very large, and it is often very difficult to work on different sections without getting lost within the project. This is not necessarily specific just to Smartsheet, but functionality that would enable modularization or more easy navigation to work on multiple parts of a sheet at once would be helpful.
- Communication tools within Smartsheet are not very functional or not very intuitive. Because of its collaborative nature, it would be helpful for there to be more capabilities for communication within the application about changes being made or between users who are editing the same sheet.
It is an invaluable tool for project management but can also be used for any sort of complex task management. The only scenarios in which it seems like it is not very appropriate is if the project or task is too small to require much planning or has too few people to require any sort of collaboration or visibility.
- The sharing option allows you to share data with external partners/co-workers.
- The linking option allows you to update multiple pages at once.
- This is great for business meetings as you are able to export information into Excel and print data.
- Sometimes I experience linking issues with particularly lengthy sheets.
- Easy collaboration without having to have a program installed on your machine.
- I like the ability to export gantt charts to a variety of output formats (excel, pdf, .png, XML, Google Sheets)
- Comments and attachments are easy to attach and access.
- Very easy to switch views from Gantt to Card (Kanban) to Grid to Calendar view.
- Would be nice to have a burn down chart to track remaining tasks and forecast over/under progress.
- It really does most things pretty well.
- Ability to have multiple people access data at a time they need, without worrying that another person may have the sheet 'locked' as often happens when working with Excel.
- The ability to set automatic reminders. I use it for those things 60, 90, even 365 days in the future. I tell it when I want to be reminded and I get an email in my inbox telling me a task needing attention (much more effective than the task function in my email that I am great at ignoring).
- The formatting capabilities allow for a lot of data to be managed effectively.
- The conditional formatting is not as robust as in Excel.
- Project management template is outstanding. Mirrors MS Project without the learning curve.
- Web forms automate all processes including surveys, training registrations, etc.
- Operates like Excel so anyone with Excel experience can readily use it.
- It's collaborative.
- Collaboration on any project
- Job orientation training
- Training rosters
- Training feedback
- Surveys of any kind
- Project management templates including built-in Gantt charts
- Easy to use. It is a very intuitive natural interface for business and technical users.
- Dashboards were relatively easy to create and use.
- SaaS model allowed easy but secure access across geographically disparate resources.
- Workspaces feature was rarely used for comments or sharing.
- Report builder took some getting used to.
- Easy to share with non-Smartsheet users for visibility and collaboration
- Just the right level of complexity. Anyone who has put together a project plan before can do this.
- Multiple ways of planning and displaying your project. Also easy to export to a pdf for historical or formal reasons.
- There may be a few features that would be nice to have a shortcut button for, like indenting / outdenting
- Smartsheet has been excellent for assigning tasks to teams. By entering my team member's contact information and a due date, I can easily set reminders to keep them on track and to notify me if anything is running behind.
- Reports are an excellent way to pull information from multiple sheets. One of our teams uses this for each staff member to track their case load. Team leads are able to easily see the status of each assignment.
- Smartsheet is easy to learn. We have staff ranging widely in age and technology use. The functionality of Smartsheet is like a mix of Excel and Google Docs with the additional perk of alerts and easy collaboration. We have found that anyone who has even basic experience with Excel can easily work in Smartsheet with a little extra guidance.
- Conditional formatting automatically changes as a project is updated by you and/or your team. This makes it easy to identify where the project is on track and where it is falling behind with just a quick glance at your Gantt Chart or spreadsheet.
- We have found that Excel and Google Docs "super users" get frustrated with some of the nuances of Smartsheet compared to their regular programs. Making sure that Smartsheet is not "just another tool" that our staff has to use, discussing the differences between Smartsheet and those programs, and explaining why we chose to use Smartsheet for a particular program, makes a huge difference in staff perception.
- A lot of front end planning and organization is needed for some of the larger projects in Smartsheet. It is best to start small and play in the software so you can learn how everything works, before developing a robust program Gantt and reporting system.
- Our organization has looked at expanding the use of Smartsheet to report consistently across our seven divisions. However, the dashboard functionality is not quite where we need it.
Here at Minnkota Power, we use Smartsheet to manage and track our many construction projects throughout the year. We have essentially replaced Microsoft Project with Smartsheet due to the ease of creating custom GANTT charts and schedules and the ability to share and collaborate on these schedules across our department.
Currently we are only using Smartsheet heavily in the Engineering department, but our Operations department has taken an interest and is ramping up their usage. Occasionally we send out update requests to other departments in the company but I would not consider them to be users of the software. The main problem that Smartsheet addresses is it puts everything in one place. Not only does it eliminate everything being stored in a huge folder hierarchy where no one can ever find anything, but it puts everything online and can be accessed from anywhere! It is also great for reminders and updates on a regular basis.
- Collaboration - The ability to easily share a sheet with another co-worker or multiple people and have everyone making updates all at the same time is really nice.
- Integration - Smartsheet integrates with Outlook very nicely. I can easily send updates, notifications, or any other messages to anyone through email. This eliminates having to open up my email and type up a message about a particular row or item in Smartsheet. Using the send row option it just sends a nice snapshot of the row with a brief message! We also use Microsoft SharePoint here at Minnkota as well and I have found the publishing function of Smartsheet to be very useful! This allows a sheet to be embedded into a webpage or SharePoint site for viewing access to any of our SharePoint users, which is everyone at our company.
- Keeping up with the times - There seems to always be new features or updates coming out for Smartsheet. A lot of other companies do this with their software as well, but usually it just adds a lot of confusion with the product. SmartSheet is all about keeping their product user friendly. Not to much training is really required for Smartsheet. I'd say that most anyone could sign up for the 30 day trial and have a good portion of the product features figured out. However, the best practices take time and a lot of trial and error before you can figure out what works best for your company.
- Support - Smartsheet has a link on their website where you can shoot an email off about anything. They are usually pretty quick to respond and if what you are requesting is not "possible" then they seem to always have a work-around for everything!
- There are minor details dealing with the dependency settings on a sheet. For some reason, if you are trying to utilize cell linking, the parent rows can not be used as a source. This really isn't a huge issue and I have been using a work-around for this but it is one thing that would be nice to just be built in.
- Reporting - Reports are very nice because they can pull information from multiple sheets. However, when information is pulled in, the Parent-Child relationships are not shown. Everything appears to all be on the same hierarchy level. The only work-around I found for this is to apply formatting to the parent rows, basically filling the rows with color or editing the font.
- A new update is coming out that eliminates the ability for users with Admin access to a sheet to be able to edit column properties. This was one of the strengths of SmartSheet that they seem to be taking away for some reason. Now, I just don't really see the benefit of being an Admin of the sheet versus an Editor. Only Admins that are actual Licensed Users can edit column properties. Seems to be a way for SmartSheet to get more money by forcing companies to purchase more licenses.
Smartsheet is well suited for data that comes from multiple sources or people. If you are just using it for your own personal information tracking, then I would just opt for Excel or some other cheaper software. It is also great for anything that deals with a schedule or dates. The dependency settings that are built in are nice and if you are used to using Microsoft Project then you will catch on fast. Even without Project experience though, the dependency settings are easy to learn.
Smartsheet Scorecard Summary
Feature Scorecard Summary
Three tiers cover Smartsheet's pricing options. The Basic level provides core features for small groups of individuals, while the Team level is recommended for groups of up to 50 people and supports more user features, allows multiple sheet creators, and has reporting functions. The Enterprise level is a custom fit tier for groups of greater than 50 individuals or companies, and may include dedicated support personnel if desired.