Timesheet Tip: Linking Projects Together

Linking Projects Together

If you’re using Replicon’s timesheet software to track projects, then you’re probably already well-versed at dividing those projects into tasks and sub-tasks. In Web TimeSheet, these tasks are naturally linked to the parent project. But what happens when you need to link two or more entire projects together? How do you do it?

For some customers, the use of “Client Name” or “Department” is sufficient. However, there may be times when you need to create dependencies for the purposes of tracking, timelines and reporting. Imagine a case of three projects that are all part of one large project, such as product design. One project may focus on “Creating the Product.” One project may require a “Factory to be Built.” And one project may necessitate “Hiring Staff” to support the new product. In a lot of cases, these activities cannot be tasks of the same projects, so here is how we would treat those in the timesheet software.

The solution is to create a new Project-Level User-Defined Field (UDF) to use as a linking code between these projects. Here’s how:
Step 1: Create a new UDF at the Project level. Use text, numbers, or even drop-down as the “Type.”
Step 2: Go to each project that is part of this same “group” and add the same code to each one (i.e. ABC123).
Step 3: On any project report, add this new UDF field as a column. We recommend that you also group the report on this new column (in the “Rows Group By” section on the Grouping tab of the report settings).
Step 4: Run the report. Make sure to select any appropriate filters to narrow down your report range.

Each one of the groupings you create will be its own section. So, if you are looking for totals on hours, $ amounts, or anything else numerical, the sums will be provided.

If you are looking for an additional level of complexity, you can use the project link code nomenclature to perform some basic functions.
Example A) Sequence. Project groupings that naturally follow each other can be named ABC123, ABC124, ABC125, etc.
Example B) Phases. Projects that are essentially phases of a larger project can be named to reflect that: NEWPhase1, NEWPhase2, NEWPhase3, etc.
Example C) Dates. Dates can be factored into the code as well: ABC123-Dec2011, ABC123-Jan2012, ABC345-Jan2012, etc.

Lastly, if your project code field is not being used for anything, then you can perform the same functions as above but without having to create a new User-Defined Field.

The end result: greater visibility of the total time, money and work going into your projects – as a whole and broken up by its supporting projects. Once you’ve linked your projects with the time-tracking software, your employees can associate their hours with any of the linked projects – and their individual tasks – right on their online timesheets. Managers can tailor reports however they choose to track overall progress for in-house use, client billing, payroll or other needs.

Avatar
ABOUT THE AUTHOR
Replicon
Replicon provides award-winning products that make it easy to manage your workforce. With complete solution sets for client billing, project costing, and time and attendance management, Replicon enables the capture, administration, and optimization of your most underutilized and important asset: time.
Get started today.
Set up a free trial based on your business needs. Start Free Trial

4 Ways to Drive Efficiency in Your Nonprofit

HR Daily Advisor | Dec 03, 2019 By Maggie Deptuck, Global SVP at Replicon Nonprofit organizations (NPOs) have a lot on their plates. Aside from operating with limited funds, maintaining…Read More

Global Compliance Desk – Nevada

Nevada Enacts Bill Regarding Paid Personal Leave and Minimum Wage Nevada has recently passed a personal leave law (SB312), which, valid from January 1, 2020, will require private employers with…Read More

Global Compliance Desk – United States

Overtime Pay Update The U.S. Department of Labor has declared a final rule to make 1.3 million American workers qualified for overtime pay under the Fair Labor Standards Act (FLSA). …Read More

Top 10 Ways to Get Employees to Fill in Timesheets

  It comes as no surprise to anyone in the business world that there is one cardinal rule when it comes to employee time tracking: employees hate to fill out…Read More

Will AI replace consultants?

The onset of AI and smart machines automating formerly-human jobs has been discussed at length as of late -- often in relation to manufacturing and manual labor jobs. And yet,…Read More

6 steps for fast-tracking profitability in your consulting practice

Advice aimed at entrepreneurs and small businesses tends to be heavily product-oriented, but in reality the majority of US small businesses fall under the “Professional, Scientific, Technical, and Other Services”…Read More
  • Cloud
  • In The News
  • Corporate
  • Professional Services Management
  • Project and Program Management
  • Shared Services Management
  • Time and Attendance Management
  • Workforce Management
  • Customer Feature
  • Feature Update
  • Time Intelligence
  • Industry News
  • Webinar Recap
  • Global Compliance Updates
  • 
    Chat with us
    How can we help you?