Dec 10 2021
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?
View best response
Dec 13 2021
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.