PowerApps is a low code / rapid application development product from Microsoft that allows users to quickly build apps.
$20
per month per user
Smartsheet
Score 8.3 out of 10
N/A
Smartsheet is an online project management and collaboration tool. It includes automated alerts, instantaneous updating and sharing across team members, resource management, nested tasks organized in a hierarchy, a Gantt chart view, exportable and automated reports, and integration with email.
Along with PowerApps we evaluated Smartsheet for use and we determined that PowerApps provides a great deal more functionality and flexibility. Especially when you consider it is nested in SparePoint and all the additional functionality that SharePoint provides. PowerApps …
PowerApps is well suited for "quick-wins" and fast prototypes of business solutions. It also is beneficial for situations where business partners and developers work together - it allows the business folks to provide a "quick-and-dirty" prototype which is then fleshed-out by developers that are trained experts on the platform. The interactive and easy to understand representation of the solution allows business partners to "see" the solution and add, remove, or correct aspects of it themselves. It provides a common view and understanding of the actual solution across business units and tech teams. PowerApps, being a low-code\no-code platform is not well suited for business processes that require many complex computations or large amounts of custom code - such as solutions that are better architected as Web Site or "full-blown" desktop solutions. There are solutions that are just not easy or quick to accomplish in a low-code\no-code platform. Enterprise Architects should know the difference, however business partners often try to create a solution and only when stuck because it becomes too complex do they engage a tech team for assistance - at which point there are sunk-costs involved and hinderences to re-platforming the solution
Smartsheet shines for collaboration. When you have multiple people involved with planning events Smartsheet makes it easy to share and collaborate. For instance, multiple people can be in Smartsheet working at the same time. Also setting permissions for exactly those who need to know is quite easy with Smartsheet. For data analytics and general spreadsheet purposes Excel is better but for project management and event planning Smartsheet is superior
Power Apps has formats that are pre-built that don't require any coding which makes it easier to achieve your vision. This does become a challenge if your App needs don't fit into that format.
We deal with a ton of data so the fact that you can connect to any data source in addition to their pre-stablished data connections makes the process a breeze.
The online learning resources and tutorials are helpful as well for those who are tech savvy.
Its hard to overstate the value of familiarity. Being able to use a tool that has some familiarity takes away the time needed to train and orient employees on a new tool and allows an organization to hit the ground running.
Smartsheet covers most of the basics of a project management tool, the usual tasks, milestones and project viewing options.
For data viewing, you get multiple data viewing options including a calendar view (good for marketing teams and those who work around scheduling), Kanban, Gaant etc
Smartsheet set up is similar to Excel, yet when you upload an Excel file, things like conditional formatting are lost. Smartsheet has its own conditional formatting, and you have to reinstate the rules. It would be great if those would apply automatically once a file is uploaded
Some Smartsheet management and access rules can take some tweaking to work properly. This may be a case of offering more info to admins so they can apply these better and with more efficiency
It definitely meets our needs as far as organizing and archiving our tasks and files. As we train more staff to view it, I see opportunities for more improvement, which I am sure this program can handle. I look forward to seeing continued improvement from Smartsheet on their capabilities and functionality.
PowerApps is a great solution and I have spent the last year familiarizing myself with the platform and building custom applications to complete a whole range of tasks such as asset management, custom invoice generation, and item restriction tracking. We as a company have barely begun to scratch the surface of what can be achieved with PowerApps.
Smartsheet is very easy to learn. However, while I have been able to pick it easily, Microsoft Excel and Project super users that I have trained on Smartsheet get bogged down in the differences and can find it frustrating. Explaining the differences ahead of time and why Smartsheet is being chosen instead of a different software seems to counteract those reactions
The community forums are extremely responsive to questions asked, there is a good body of online documentation and many community posts to draw from. Although the platform has changed, which means some of the posts are out of date and the solutions provided aren't relevant. Of relevance, I read over 400 articles plus documentation to get this first app built in SharePoint, move it to SQL and make it work exactly the way it should.
I give this rating because it fills a niche in the market. MS Project scares many away from proper task management but there are limited tools our there, especially cloud-based that are mobile-friendly. Smartsheet fills this market gap, especially for small to medium-sized businesses. IT is not fair to compare it to MS Project, but fairer to see what gaps it fills.
It's absolutely paramount to take a few minutes to actually play with the software. It's nearly impossible to do anything wrong or make a mistake which cannot be fixed easily. Under the help menu is Live Training option. After you familiarize yourself with the commands, watch the live training for some in depth understanding of how to make the software fit your needs perfectly.
Much cheaper, much more customizable, and easier to use. There is not much of a learning curve and the licensing cost is much cheaper. PowerApps does one thing very well, whereas other platforms are mediocre. There is much more customization possible for your in-house workflows that you can build yourself vs using NetSuite engineers to build it for you.
Jira and Redmine are much more robust and technologically advanced project management solutions. I enjoy using either when managing a very large project. However, I prefer to use Smartsheet for my smaller to medium sized projects. As for Google Drive - I would say that Google sheets and Smartsheet are almost identical in my opinion when it comes to functionality. Personally I prefer to manage smaller projects via Google Drive, but it is a personal preference!
It has given us a focal point for development. We now have the possibility of connecting to mobile and the default SharePoint online interface isn't always easy to manipulate. PowerApps has given us an opportunity to improve our user experience.
An improved user experience has given us a better shot at compliance. When users don't fight the environment, they don't gravitate towards workarounds or non-compliance.
As lists and libraries change, the platform scales pretty well.
Having users with the capability to create their own forms and tools has dialed back the app dev need (there is a balance though) and distributed power to the process architects and people who actually need the solutions in the first place—much more efficient model of service delivery: self-service.
