TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Lightning Tools Lightning Conductor

    Score9 out of 10
    Mid-Size Companies (51-1,000 employees)
    The Lightning Conductor is a content aggregation tool for Microsoft SharePoint Online and Microsoft Teams. Users can build rich, modern content reports based upon SharePoint lists, SharePoint Search, Microsoft Graph or Microsoft 365 Groups. Content can be aggregated from lists and libraries, and other applications such as Planner, To Do, OneDrive, and Teams.

    $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 Lightning ConductorSmartsheet
    Editions & Modules
    Lightning Conductor WSP
    From 1950
    per year One WFE
    Lightning Conductor Enterprise Edition
    POA
    per year Four or more WFE
    Lightning Conductor Online
    From 2200
    per year per installation
    Lightning Conductor Plus (Includes Data Viewer)
    From 2500
    per year per installation
    Lightning Conductor Online Enterprise Edition (>10,000 users)
    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 Lightning ConductorSmartsheet
    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 Lightning ConductorSmartsheet
    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 Lightning ConductorSmartsheet
    Project Management
    Comparison of Project Management features of Lightning Tools Lightning Conductor and Smartsheet
    Feature
    Lightning Tools Lightning Conductor
    8.6
    2 Ratings
    11% above category average
    Smartsheet
    9.1
    129 Ratings
    17% above category average
    Task Management8.82 Ratings9.8126 Ratings
    Search8.42 Ratings00 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 Lightning Conductor and Smartsheet
    Feature
    Lightning Tools Lightning Conductor
    -
    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 Lightning ConductorSmartsheet
    Small Businesses
    Flock
    Score9.5 out of 10
    Any.do
    Score8 out of 10
    Medium-sized Companies
    Troop Messenger
    Score9.8 out of 10
    KanbanFlow
    Score7.3 out of 10
    Enterprises
    Cisco Business Edition 7000 (discontinued)
    Score9 out of 10
    Microsoft To Do
    Score7.9 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Lightning Tools Lightning ConductorSmartsheet
    Likelihood to Recommend
    9.0
    (4 ratings)
    9.3
    (146 ratings)
    Likelihood to Renew
    9.1
    (1 ratings)
    9.0
    (24 ratings)
    Usability
    -
    (0 ratings)
    9.2
    (17 ratings)
    Performance
    -
    (0 ratings)
    10.0
    (1 ratings)
    Support Rating
    9.1
    (1 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 Lightning ConductorSmartsheet
    Likelihood to Recommend
    Lightning Tools
    Having experience of SharePoint On Premise and also SharePoint Online, there isn't an out of the box app/webpart that enables you to 'roll up content' from a variety of source's (in my case SP Lists, but there are many other data sources it works with) across site collections with an easy to use and intuitive interface which is what Lightning tools excels at.
    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
    • Aggregate documents across SharePoint site & libraries
    • Filtering for owner/person responsible & due dates
    • Ease of end-user filtering on columns
    • Color-coding & other formatting
    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
    • Mobile Friendly
    • Calendar/Gantt views
    • Complex/Custom Logic
    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
    The Lightning Tools support team responds quickly, and team members are very friendly and helpful.
    Read full review
    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
    I haven't found another product to compare this one to. Only in SharePoint Online which has a similar App 'Highlight Webpart' ... it's far too complicated to set up and requires learning yet another language and exporting and importing via PowerShell to get any real results that would be useful.
    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
    • Policies easier to portray
    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 Lightning Conductor Screenshots

    Screenshot of MODERN SHAREPOINT LIST ROLLUP
The Lightning Conductor is a SharePoint Content Aggregator that can be configured quickly by business users. The Lightning Conductor can be used to aggregate content from SharePoint Lists such as Tasks, Document Libraries, Contact Lists, and Custom Lists making it easy to view content in one place even if it is distributed across many sites and site collections. Key data can be highlighted using conditional formatting and data-bars as shown. Content from Search and Microsoft Graph can also be aggregated with the Lightning Conductor.Screenshot of CONTENT AGGREGATION WITHIN MICROSOFT TEAMS
The Lightning Conductor Web Part can be used within Microsoft SharePoint or Microsoft Teams. Even if content is stored within SharePoint sites, it is useful to have aggregated Documents, Tasks, Announcements, Calendars or Custom Lists from multiple sites displayed in a single handy view in Microsoft Teams. The Lightning Conductor can be added as a Teams Tab in any Microsoft Teams Channel.Screenshot of BUILDING REPORTS ON MICROSOFT GRAPH
The Lightning Conductor can be used (without code) to aggregate content from Microsoft Graph as well as Search and SharePoint Lists. This example displays Microsoft Planner Plans and Microsoft Planner Tasks where users can Add new Tasks, Assign Users to Planner Tasks, Delete Tasks, and Complete Tasks. The same can be performed on Microsoft To Do items and displayed within Modern SharePoint pages or Microsoft Teams Tabs. The Lighting Conductor can also contain multiple views of content, making it ideal to display all of your tasks from SharePoint Task lists, Microsoft To Do and Microsoft Planner in a single web part or Teams Tab.

*Microsoft Graph Reports are only available for SharePoint Online and not SharePoint 2019.Screenshot of BUILDING REPORTS ON MICROSOFT 365 GROUPS
Powered by Microsoft Graph, the Microsoft 365 Group Rollup Provider enables users to aggregate content by browsing and selecting Microsoft 365 Groups. Within Microsoft 365 Groups, you’ll be able to select entities such as Drive Items, Owners, Members, Planner Plans, Planner Tasks, Events, Posts,  Sites, Lists, and Calendars.

*Microsoft Graph Reports are only available for SharePoint Online and not SharePoint 2019.Screenshot of AGGREGATING USING SEARCH
When performance is critical, search can be used for rollups. The Lightning Conductor offers three data source configurations to get to content. Object Model (Real Time Aggregation from SharePoint Lists), Microsoft Graph (Aggregation from Graph Entities such as Planner, OneDrive, Outlook), and Search. The Search Data Source enables the aggregation of content from large SharePoint lists and libraries when performance is critical. Thousands of documents can be displayed in under a second using Search.Screenshot of HIGHLIGHTING KEY BUSINESS DATA WITHIN VIEWS
End users and Site Owners can highlight the data that is important to them, the data that they need to prioritize. Using conditional formatting, data bars, and icons, conditions can be configured to highlight the data that is most important. Icons and Data Bars can be any color or size desired. Examples include highlighting High Priority tasks, Showing data bars for the completion progress of Tasks, or indicating which tasks are assigned to any particular user.