TeamTime - Custom Columns

This guide will tell you a little about custom columns, and how to set them up:


What are Custom Columns?

Custom Columns are extra columns you can add to your timesheet:

This allows you to capture more data from your users, and use it in Reports and Analysis. Here are some example columns:

  • Overtime (Yes/No)
  • Cost center (Text)
  • Client (Choice)
  • Bug ID (Number)

Custom columns are also automatically pulled into the Overview site.

Setting up Custom Columns

To add a custom column, follow these steps:

1. Open the TeamTime Content Type:

On the Settings page, click Timesheet Column Management

At the bottom of the page click the TeamTime Content Type link

This opens the TeamTime Content Type in a new window. Columns added to the Content Type are displayed in all TeamTime sites in the site collection. If the link above is replaced by a warning message, then you will need to contact your site collection administrator in order to add the column(s).

2. Add the column to the Content type:

To add a new column to the Content Type, click the Add from new site column link at the bottom left of the page

You will then be able to create a new column, in exactly the same way that you would add a column to a normal list. Please note that TeamTime is only compatible with the following column types:

 

  • Single line of text
  • Multiple lines of text
  • Choice (menu to choose from)
  • Number (1, 1.0, 100)
  • Currency ($, ¥, €)
  • Date and Time
  • Yes/No (check box)

 

Once you have added your column, you can close the Content Type page, returning you to the Timesheet Column Management page

3. Choose the column order and transform

To choose the order you'd like the columns to be displayed in on the timesheet, change the Order drop downs on the Timesheet Column Management page:

The Transform drop down also allows you to choose how the column's data should be handled when in the Month analysis. More information on this can be found here: Column Management

4. View your data

Once your customs columns are in place, you can use the data with these methods: