Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We have an OOTB Project Tasks List that works great for our needs.

However I was looking to make it a little more quicker and easier to read.

I would like to add a column called "status" and have three main colored circles (Red, Green and Yellow) to indicate the health of each of the project tasks.

I am assuming that the indicators would be driven by the percentage complete field on each task. But ideally would love to drive it with a calculated value based on a Time/Percent complete ratio.

How do I go about doing this?

share|improve this question
add comment

2 Answers 2

up vote 1 down vote accepted

This solution will do what you are asking for SP 2007 and higher. The Status indicator show Green and Red, but you can modify the calculated field to have the Status column show a third color as well.

The output will look like so: enter image description here

Steps:

  1. Create a Status column (Calculated field) and a Status Text column (Choice field)

    enter image description here

  2. Configure the Status column like so:

    enter image description here

  3. Configure the Status Text column like so:

    enter image description here

share|improve this answer
add comment

This is not available out of the box.

My blog features a technique that I call the HTML Calculated Column that can do what you want. You might want to start with the article I published this week (it directly answers your question about percent complete), but there are dozens of others:

Trick or Treat? Text to html, the wicked no-code way

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.