TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Lightning Tools Data Viewer

    Score9.1 out of 10
    Mid-Size Companies (51-1,000 employees)
    The Data Viewer provides data visualization in the form of reports or charts that can be created and customized to suit a business's needs. Silos of data exist in most organizations and yet contain valuable insights into how well the organization is performing and where action is needed. Those silos often include Microsoft Excel workbooks, Microsoft SQL Azure databases, On-Premises data sources accessible through OData or Business Connectivity Services and even SharePoint Lists. These data…

    $2,200

    per year per installation

    Smartsheet

    Score8.3 out of 10
    N/ASmartsheet 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.

    $12

    per month per user (up to 10 users)

    Pricing
    Lightning Tools Data ViewerSmartsheet
    Editions & Modules
    Data Viewer OnPrem
    $1,000
    per year Per installation, 1 x WFE
    Data Viewer Online
    $2,200
    per year per installation
    Data Viewer OnPrem Enterprise Edition
    POA
    per year Per installation, 4+ WFE
    Data Viewer Online Enterprise Edition
    POA
    per year per installation
    Pro
    $12
    per month per user (up to 10 users)
    Business
    $24
    per month per user (3 user minimum)
    Enterprise
    Contact Sales
    Advanced Work Management
    Contact Sales
    Offerings
    Pricing Offerings
    Lightning Tools Data ViewerSmartsheet
    Free Trial
    YesYes
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional DetailsPrices stated are minimum per installation for "stock" products. $2.20 per user / year on top of base price. Enterprise editions can be amended to suit business needs if deemed necessary, additional costs incurred and TBD. All packages include free technical support. Free upgrades available to latest versions of tool as they are released. (online version)A discount is offered for annual billing.
    More Pricing Information
    Community Pulse
    Lightning Tools Data ViewerSmartsheet
    Considered Both Products
    Lightning Tools
    No answer on this topic
    Smartsheet
    No answer on this topic
    Key User Insights
    Would buy again
    No answers on this topic
    90%
    Would buy again
    62 Answers
    Delivers good value for the price
    No answers on this topic
    97%
    Delivers good value for the price
    58 Answers
    Happy with the feature set
    No answers on this topic
    88%
    Happy with the feature set
    61 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    98%
    Lived up to sales and marketing promises
    47 Answers
    Implementation went as expected
    No answers on this topic
    96%
    Implementation went as expected
    51 Answers
    Features
    Lightning Tools Data ViewerSmartsheet
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Lightning Tools Data Viewer and Smartsheet
    Feature
    Lightning Tools Data Viewer
    9.1
    1 Ratings
    12% above category average
    Smartsheet
    -
    Ratings
    Customizable dashboards9.11 Ratings00 Ratings
    Report Formatting Templates9.11 Ratings00 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Lightning Tools Data Viewer and Smartsheet
    Feature
    Lightning Tools Data Viewer
    8.2
    1 Ratings
    5% above category average
    Smartsheet
    -
    Ratings
    Drill-down analysis6.41 Ratings00 Ratings
    Formatting capabilities9.11 Ratings00 Ratings
    Report sharing and collaboration9.11 Ratings00 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Lightning Tools Data Viewer and Smartsheet
    Feature
    Lightning Tools Data Viewer
    3.6
    1 Ratings
    73% below category average
    Smartsheet
    -
    Ratings
    Pre-built visualization formats (heatmaps, scatter plots etc.)3.61 Ratings00 Ratings
    Project Management
    Comparison of Project Management features of Lightning Tools Data Viewer and Smartsheet
    Feature
    Lightning Tools Data Viewer
    -
    Ratings
    Smartsheet
    9.1
    129 Ratings
    17% above category average
    Task Management00 Ratings9.8126 Ratings
    Resource Management00 Ratings10.0108 Ratings
    Gantt Charts00 Ratings9.0109 Ratings
    Scheduling00 Ratings9.8111 Ratings
    Workflow Automation00 Ratings9.2100 Ratings
    Team Collaboration00 Ratings10.0122 Ratings
    Support for Agile Methodology00 Ratings8.981 Ratings
    Support for Waterfall Methodology00 Ratings9.079 Ratings
    Document Management00 Ratings9.2101 Ratings
    Email integration00 Ratings9.0100 Ratings
    Mobile Access00 Ratings8.096 Ratings
    Timesheet Tracking00 Ratings9.762 Ratings
    Change request and Case Management00 Ratings8.169 Ratings
    Budget and Expense Management00 Ratings8.075 Ratings
    Professional Services Automation
    Comparison of Professional Services Automation features of Lightning Tools Data Viewer and Smartsheet
    Feature
    Lightning Tools Data Viewer
    -
    Ratings
    Smartsheet
    7.9
    66 Ratings
    3% above category average
    Quotes/estimates00 Ratings8.144 Ratings
    Invoicing00 Ratings7.537 Ratings
    Project & financial reporting00 Ratings8.760 Ratings
    Integration with accounting software00 Ratings7.332 Ratings
    Best Alternatives
    Lightning Tools Data ViewerSmartsheet
    Small Businesses
    Chartio (discontinued)
    Score7.5 out of 10
    Any.do
    Score8 out of 10
    Medium-sized Companies
    Jet Reports
    Score9.5 out of 10
    KanbanFlow
    Score7.3 out of 10
    Enterprises
    Kibana
    Score8.4 out of 10
    Microsoft To Do
    Score7.9 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Lightning Tools Data ViewerSmartsheet
    Likelihood to Recommend
    9.1
    (1 ratings)
    9.3
    (146 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    9.0
    (24 ratings)
    Usability
    -
    (0 ratings)
    9.2
    (17 ratings)
    Performance
    -
    (0 ratings)
    10.0
    (1 ratings)
    Support Rating
    -
    (0 ratings)
    8.1
    (45 ratings)
    Online Training
    -
    (0 ratings)
    7.0
    (1 ratings)
    Implementation Rating
    -
    (0 ratings)
    10.0
    (6 ratings)
    User Testimonials
    Lightning Tools Data ViewerSmartsheet
    Likelihood to Recommend
    Lightning Tools
    Lightning Tools Data Viewer is well suited for re-surfacing data and customizing its look and feel.
    Read full review
    Smartsheet
    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
    Incentivized
    Read full review
    Pros
    Lightning Tools
    • Shows Lists created on different sites to be seen and controlled on another site in a Tenant
    • Allows selection of layouts and coloring way beyond what other programs do.
    • Easy to learn and very functional.
    Read full review
    Smartsheet
    • 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
    Incentivized
    Read full review
    Cons
    Lightning Tools
    • Data Viewer has a graph feature that is old school flat design. We loved the In House real 3D graph Lightning Tools program.
    Read full review
    Smartsheet
    • 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
    Incentivized
    Read full review
    Likelihood to Renew
    Lightning Tools
    No answers on this topic
    Smartsheet
    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.
    Incentivized
    Read full review
    Usability
    Lightning Tools
    No answers on this topic
    Smartsheet
    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
    Incentivized
    Read full review
    Support Rating
    Lightning Tools
    No answers on this topic
    Smartsheet
    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.
    Incentivized
    Read full review
    Implementation Rating
    Lightning Tools
    No answers on this topic
    Smartsheet
    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.
    Read full review
    Alternatives Considered
    Lightning Tools
    Lightning Tools Data Viewer is much easier and more powerful than Infowise similar viewer in their lineup. In this case, we use Data Viewer over the one offered by Infowise.
    Read full review
    Smartsheet
    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!
    Incentivized
    Read full review
    Return on Investment
    Lightning Tools
    • It allows us to do things that would take a great deal more time to duplicate in SharePoint
    • It cuts down on ugly looking built in SP list layouts
    • Users find it easy to access, thus this product is more productive
    Read full review
    Smartsheet
    • This has really opened up collaboration across teams. A lot less working in silos.
    • It hasn't fully replaced any one tool so it means having to go to another place. Hopefully, we can eliminate a tool or two in the next six months.
    Incentivized
    Read full review
    ScreenShots

    Lightning Tools Data Viewer Screenshots

    Screenshot of DISPLAYING EXTERNAL DATA WITHIN SHAREPOINT OR MICROSOFT TEAMS
The Data Viewer Client Side Web Part can be configured by Business Users within a few minutes to display Line of Business Data from Data Sources such as Excel,  SQL Azure, Business Connectivity Services, OData and SharePoint Lists.  Connections to an organizations data such as Customer Relationship Management Systems, Accounting Systems, or Custom Databases can be connected, giving business users a live up-to-date view of business information within the context of their SharePoint Team Sites or Microsoft Teams Tabs.Screenshot of HIGHLIGHTING KEY BUSINESS DATA (NO CODE)
Conditional formatting can be used to highlight key business data. Overdue Tasks, Low Stock, Currency Exchange Rates, Sales Revenue are examples of data to highlight visually allowing for a quick reaction time. Key Financial Indicators and Key Performance Indicators can be configured with a simple dialog and no need to write any code. Choose colours, icons or data bars to highlight key data.Screenshot of SELECTING AND STYLING ICONS
Icons can be chosen as part of the conditional formatting to make data stand out. The Office 365 Fabric icons can be selected and styled and applied to cell values. Pepper pots, Smileys, Envelopes and more icons are available. There are hundreds of options to choose from to highlight data that needs to be acted upon.Screenshot of DATA VIEWER CAN BE A GRID OF DATA OR A CHART IN SHAREPOINT OR MICROSOFT TEAMS
The Data Viewer can be used within Microsoft SharePoint Modern Sites or Microsoft Teams Tabs as a Grid of Data with styling or as a Chart which can be configured. The Charting Feature allows for Pie, Donut, Column, Line, Area, and Scatter Charts which can all be configured and displayed in 2D or 3D.Screenshot of TREEMAPS
summary information can be displayed within a TreeMap next to the detail. Users will be able to see trends, and how the business is performing  using the TreeMap view of data.Screenshot of CHARTS AND GAUGES
The Data Viewer is used to represent data in multiple ways using Gauges, TreeMaps, Multiple Series Charts, and Pie Charts.