SOLVED

Custom Formula Field is empty on the Project Center page in Project 2016

Occasional Contributor

Hi,
I created a custom enterprise field "Today Status" on the PWA as a formula. The formula is:

 

 

Switch(([Actual Duration] / [Duration]) * 100 = 100, "Project Completed", ([% Complete] < 100) And (DateDiff("d", [Finish], Date()) < 0), "Delayed", ([% Complete] < 100) And (DateDiff("d", [Finish], Date()) > 0), "In Progress")

 

 

I added it to the Project Center summary page. However, no data is appearing. Can you please guide me what is the issue?

 
 
156226-image

 

156227-image

 

1 Reply
best response confirmed by nooruls143 (Occasional Contributor)
Solution

Hello @nooruls143 ,

You will need to open each project, edit the project, then save and publish the project for the field to calculate and update. It will not update automatically on page load etc. 

Paul