top of page

SIMPLE PROJECT SOLUTION

Download for free along with our guidance notes:

Note you need to be logged into Smartsheet to access the form. 

While Smartsheet is pretty intuitive, the level of flexibility and choice can be daunting for some people just getting started.

Given we're experts in Smartsheet and experts in Project Management, we've created a project template that leverages the power of Smartsheet into a simple project solution.  

This is one of many templates we have and is completely modular.  It can easily be upgraded to incorporate additional assets as required, such as RAID logs, budget, change control, as required by the business and project methodology.

Any questions or for our support and further templates >>get in touch!​​​<<

Don't have a Smartsheet account?  Get a >>30-day free trial here<<

'Thanks to Prodactive and Smartsheet, projects have never been more organised. Our scientists can look at time plans and spot dependencies across departments, enabling them to plan and allocate resources more efficiently.' 

Gundeep Singh & Inês Barbosa, RxCelerate

B8EEAFF1-2C6D-478D-BAE4-C8981E4C9F81_1_105_c.jpeg

Solution Overview

What do you need: Core Smartsheet

 

Complexity: Low

 

What’s included:

  • Project schedule

  • Project dashboard

  • 2 x reports included on project dashboard

    • Summary Schedule

    • Tasks At Risk​​

Screenshot 2024-09-08 at 20.34.51.png

Description

•A simple Smartsheet solution for tracking individual projects, with a schedule (timeplan) that includes a Gantt view, critical path and ability to baseline, as well as a summary dashboard providing key project information, overall project progress and health and a summary update.

Key features

Click on the interactive views below to explore the solution

Solution details:

  • Project metadata entry – key project information (project name, project manager and description) can easily be added using the Sheet Summary and this will appear on the project dashboard.

  • Automatic task health calculation – task health is calculated automatically based on dates and completion (Red = overdue or blocked, Yellow = due in the next 2 days, Green = due in more 2 days, Blue = complete). The parent tasks are calculated based on the status of the children rows.  The formula can be switched off by sheet admins so it can be manually selected or the formula changed to reflect the requirements of the organisation.

  • Automatic project metrics calculation – the number of tasks (excludes parent rows), and the number of tasks in progress, not started, complete or blocked is also calculated so it can be added to the dashboard if required (we have left it off deliberately)

  • Tasks at risk report – any task that is either overdue or marked as ‘Blocked’ appears on the Tasks At Risk report, which shows on the dashboard.

  • Summary Schedule – key tasks can be selected to appear on a summary schedule, providing a more digestible view of key timings.

  • Automatic hierarchy visual navigation – parent rows are automatically colour-coded to aid visual navigation (they can also be collapsed and expanded to aid navigation).

  • Progress automatically calculated – task completion is indicated as % Complete. For tasks at 0%, they show as ‘Not Started’ and as ‘In Progress when between 1%-99% Complete. The % Complete for parent rows and the overall project is automatically calculated based on the tasks.

  • Predecessors, dependencies and critical path enabled – tasks can be set as successors or predecessors so the dates are automatically calculated based on the preceding task, and lead or lag timings can be added. The critical path is automatically calculated based on tasks with predecessors.

  • % Allocation and Workload Management – Workload management can be enabled and the % Allocation column used to calculate capacity.

  • Blocked tasks flag – tasks can be flagged as Blocked, which changes the Health to Red and indicated Progress as ‘Blocked’

  • Project and task status commentary with automatic date recording – task owners can provide progress commentary and the date updated is automatically recorded in the next column. The overall project commentary from Row 1 is included on the project dashboard.

  • Automations – currently deactivated, two automations in addition to the commentary update time-stamping are included as follows, noting these can be amended and added to as needed:

    • Weekly project status update – this will be sent weekly on Fridays to the project owner when activated (this could be modified / duplicated to send to all task owners if appropriate). The project owner will get this by email and can simply update the email update request, or respond to the notification in Smartsheet.

    • Update request for overdue tasks – an update request will be sent to task owners when a task becomes overdue. As above, this will be sent by email and also within the users notification centre.

 

All other standard Smartsheet features are included within this solution by default, such as the ability to view sheet history and highlight changes, view the sheet in alternative views such as Board (Kanban) view, and this solution can be modified accordingly. There are also a few hidden columns that come in handy with the solution.

bottom of page