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

[nooruls143]

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?

[#2 · Accepted 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