6 Smartsheet solutions for inventive IT departments

by The Smartsheet Team

Across all industries, IT departments provide the essential infrastructure for companies to operate more efficiently and effectively. They often coordinate and implement technology on a tremendous scale and ensure business continuity, from installing hardware upgrades to setting up single sign-on to improve data security.

IDC reported that when considering a work execution platform, IT departments add adoption criteria that move beyond cost, customer validation, and implementation time. Among these necessary checks are enterprise-grade security, scalability, long-term use, APIs and integrations, and the platform’s access to a partner ecosystem.

A simple graphic of people with a speech bubble and shining light bulb.

When stakeholders want to secure buy-in for new software-as-a-service (SaaS) platforms, IT leaders want to outline value added, quantifiable benefits, and understand why stakeholders need the platform in the first place. However, IT teams that use Smartsheet can access several add-ons, templates, and integrations and Connectors that help improve planning, increase throughput, and streamline operations.

IT leaders can see immediate value for numerous team functions such as organizing your IT help desk, implementing software migration plans, tracking unresolved tickets, and developing new software. Smartsheet provides multiple approaches for streamlining existing IT workflows and managing projects with real-time, executive visibility. Here are six Smartsheet solutions IT teams can use today.

1. IT Requests and Ticketing Template Set

As companies grow, IT departments see an increase in IT requests and tickets. These ongoing work streams can include onboarding new employees with global logins and software to setting up workstations to troubleshooting technical hardware issues.

The Smartsheet Template Set for IT Requests and Ticketing addresses many of the needs of contemporary IT departments. Included in this set is an IT ticketing dashboard, which surfaces an open tickets report and tracks request and performance metrics, displaying tickets resolved by week, month, and year.

The Unresolved Tickets Report, IT Ticket Metric Sheet, and the IT Ticket Tracking Sheet, with a built-in form, all contribute to maximizing throughput. The prebuilt IT Ticket Submission Form provides fields for created and request by dates, issue title, issue description, and the reproduction steps, and IT teams can customize the templates to fit their needs.

2. Asset Management Template Set


Screenshot of the Smartsheet IT Asset Management Dashboard

Managing hardware, workstation equipment, and computer peripherals are important responsibilities for IT departments at companies of all sizes. In addition to tracking new assets and checkout processes, IT professionals need to stay on top of asset warranty expirations and maintenance records.  

The Smartsheet Asset Management Template Set improves visibility through an asset management dashboard, which pulls data from the Asset Metrics Sheet and a trio of reports: Asset Warranty Expiration Report, Overdue Assets Report, and Assets Needing Repair Report.

The Asset Tracker Sheet can be populated through a customizable new asset intake form, in which team members can submit valuable information, including asset location and condition, from their computer or mobile device.

3. Smartsheet Jira Connector


Smartsheet + Jira logos

Agile IT departments all over the world use Jira to track ticket assignments, run project development sprints, and manage their service desks. While Jira might be your IT team’s preferred platform, some internal stakeholders might not have the permissions, technical knowledge, or time to access Atlassian’s software solution.  

Using the Smartsheet Jira Connector, IT teams can access Jira data, increase business stakeholder visibility into development projects, improve cross-functional collaboration, close tickets faster, and report on KPIs to executives. The Connector automatically synchronizes data between Smartsheet and Jira so that you can easily make bulk changes, stay organized, and provide instant visibility to business users and IT executives.

With the Connector, Smartsheet provides an easy way for information to flow from Smartsheet into Jira, so your team can map a service desk project into Smartsheet. You can easily create an easy web form to intake issues, which then import into Smartsheet and then sync to Jira so your IT help desk can work on the issues in Jira. In addition, issue status is automatically updated in Smartsheet in real time.

4. IT Office Relocation Plan


Screenshot of the Smartsheet IT Office Relocation Plan template

Whether it’s moving offices or server hosting facilities, a lot goes into an IT department relocation plan: planning, mapping, managing equipment inventory, asset labeling, and wiring. These complex transitions lead to planned business interruptions, configuring new office layouts, and making sure that every asset is tracked from facility to facility.

The Smartsheet IT Office Relocation Plan template helps with on-time readiness. Working in the template, IT professionals can build a workback schedule from the date of the move, as well as break out relocation stages and view priority, task status, who’s accountable, complete by date, and more. Once the moving date at the top of the Complete By column is entered, the remaining task complete by dates will auto populate.

Get started and save the template 

5. System Development Lifecycle With Gantt


Screenshot of the System Development Lifecycle With Gantt template

As there is a lot to consider during the system development life cycle when implementing information systems, IT teams can use straightforward tools that templatize the process and make every stage — from analysis to evaluation — more effective.

Whether you employ Agile, waterfall, or another methodology for your system development life cycle, the Smartsheet template for System Development Lifecycle With Gantt helps IT teams visualize and improve their progress with Harvey Balls and key dates. Using a digital Gantt chart in the template, they can assign tasks, then set dependencies and see how deviations from the plan impact the project.

Get started and save the template

6. Help Desk Ticket Tracker With Form

From large enterprises to smaller companies, IT help desks minimize the impact of technical glitches and hardware malfunctions while ensuring that work stations allow employees to maximize their contributions to the business. Using this Smartsheet template, IT professionals who staff help desks can speed up their support ticket clearance rate.

The customizable Help Desk Ticket Tracker Form asks business customers to define the urgency of the request, then provide issue descriptions, date, their username, department, ticket category, and attach optional screenshots to put the issue in context for the IT department.

Whenever a new ticket is submitted through the form, all the corresponding details automatically populate in the sheet. Plus, teams can set up notifications to let team members know when a ticket has been submitted, assigned, or closed. This way your team has visibility into all open tickets and can separately capture metrics for ticket closure rates, cost per ticket, and lost business hours, amongst others.

Get started and save the template

Subscribe to the Smartsheet IT Newsletter for tips, strategies, and ideas focused on helping IT professionals increase their impact on their business.