Graphical indicators in PWA

B

broot

I’ve been asked to add the following graphical indicators to show in PWA.

Task Level Status
Red = If you miss a task finish date for a critical path task
Yellow = If you miss a task finish date
Green = Task is still active
Done = check mark

The indicators are as followed:
1 = check mark
2 = Red
3 = Yellow
4 = Green

So far, I have the following code inputted into the Enterprise Fields > Task
Type (number) > Task Status >formula field:

Switch([% Work Complete]=100,1,Date()>[Project Finish],3,[% Work
Complete]<100,4)

My question is twofold:

1. What piece of code I need to add to get the Red to show for overdue
critical path task
2. Is the Date()>[Project Finish],3 the correct code to use?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top