Forum Discussion
Create a custom field with Project creation date
Toxicboumboum - I just ran a quick test. I created a new Project Center view and added the Created column to the view. When I navigated to the Project Center page and applied the custom view, the Created column correctly shows the creation date of each project. So, I do not know why you are attempting to create a custom field when the default Created field contains the data you seek. Hope this helps.
Hello dale, thank you for your reply
In fact, I'd like to group my project by Month creation ,
So I tried to build a custom field like:
Month([Created]/Year([Created]) but each time, this field returns /, so for my test, I'd just try to add [Created]
Toxicboumboum -- You will need to create an enterprise custom Project field that is the Text type. In the field, enter the following formula:
Month([Created]) & "/" & Year([Created])
After you create and save the formula in Project Web App, you will need to open each project in Microsoft Project Professional, press the F9 function key to recalculate the project (and the formula value for that project), then you will need to save and publish the project.
You cannot merely create the formula and expect it to work for all existing projects. When you create new enterprise custom fields AFTER projects have already been created, you have to open each project, recalculate the project, then save and publish it. Any project created AFTER you created the enterprise custom field will automatically recalculate the custom field value.
I think you have been skipping some very important steps. Hope this helps.
Hello Dale_HowardMVP
Once again, thank you for your help
Just to show you the weird result I get, I created two custom fields, the first one is Start Month with the following formula Month([Start]) &"/"&Year([Start]) and another field called Created Month with this formula Month([Created]) &"/"&Year([Created])
So I republish a project and here you can see the result attached
As you can see Start Month is working perfectly but I have an issue with Created date
Toxicboumboum -- After creating the formulas, did you open each enterprise project, press the F9 key to recalculate it, then save and publish it? The formulas will not work if you don't do those steps. Let us know and we will try to help you.
