Reviews (1-25 of 62)
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.
- 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.
It supports our project leadership, management, organization and resource management
- 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
- 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.
- 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.
- 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)
- 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 is a quick way to make simple and effective spreadsheets.
- The templates provided are powerful and useful.
- Role management was a snap.
- Needs more niche templates.
- More Excel type math and automated features.
- Could use a visual design overhaul.
- Cloud-based Project Management Tool - can be used across all platforms which makes communication and workflow easier.
- Modern and sophisticated tool supports many types of projects. Integration with other tools complements what we already use such as Google Calendar and Docs.
- Uncanny customer support - the Smartsheet team is Awesome! They provide both free/paid workshops, one-on-one sessions, web conferences, lab - with more features in development to help users, and so much more!
- Growing pains. There are some features I still do not know about or do not have the proper training to utilize or understand. Even though paid workshops are available in WA they are outside my area (San Francisco, Bay Area). Furthermore, if I want to be an advocate of this software to hopefully educate my company to use it I would like more available courses (prefer free) in my reach to better push it forward.
- Mixed review, some think it's easy and some find it complicated. Maybe add more integration and features or even templates to help these users.
Ask what it can do? How will it help me?
- Highly customizable. You can talk about one line/task/row in a project, or an entire sheet/project. You can share with anyone, regardless of permissions.
- Provides an efficient tool for current and previous records by keeping all your files, emails, discussions, etc. in one place.
- Adaptable style for any type of visual person. From background colors to the type of project status symbols, users will feel comfortable in creating a view that's right for them.
- Linking cells to a second spreadsheet is helpful. However, there seems to be some gaps in the designed functionality. When you want to remove something, and unlink the original, the previously linked cells in the second spreadsheet do not delete as well (requiring manual deletion and wasted time). There seems to be some problems with filtering, and then sorting a column (it won't let you). Last, the Reports feature used to show "last update" by the minute which was updated even if just looked at and resaved. A few months ago, the "last update" column would not update even if a change was made. The Smartsheet rep replied by email saying Reports require a change to a column header to make "last update" update. This is not helpful because I update the date query to sort the data I would like to look at each week in the report (and never need to change any columns). For me, this has caused a negative impact in what I thought was an effective work flow.
- Adequate customer service, but not superior. I've had immediate help through email with Smartsheet tech support. However, I would prefer a phone call for two-way interaction. Additionally, I attended a helpful webinar, but submitted a question, and was told all questions would be followed up with individually. I never heard back.
- There have been some problems with connectivity. Maybe 10–20 times in the past year, I have received "Smartsheet is unavailable at this time, check your browser" while other websites are still accessible. I had to wait anywhere from a few minutes to an hour to access our data. A few times it went offline while I was working and I hadn't saved (there is a helpful reminder that pops up every 10 minutes reminding you to save your work though).
- Smartsheet has great pre-defined templates for a variety of tasks from project management with Gantt charts, team task lists, bug tracking, to financials, etc... All templates are easily customized for your specific needs.
- Smartsheet easily allows for team communication on tasks, attaching external documents and email alerts/updates to the team.
- Easily allows for moving items / tasks around on a sheet (much easier than Excel).
- Includes many Excel type functions/formulas.
- While there are functions/formulas available, they are not always intuitive to create. Would be great if it had a function builder tool similar to Excel to simplify, or allow an excel function to be added. If you need complex formula development, stick with Excel or Google Sheets
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.