Forum Discussion
Create a custom field with Project creation date
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.
Normally I didnt open MS Project, I open the Project in Project Server then I edit it and republish
I performed a test in MS Project, so I open a Project, I press F9, I save and then I republish and now I have an empty field for my formula, before I had a / but not my custom field is totally empty
(If I redo my previous operation in Project Center, the / will appear again)
In Ms Project for [Created], I have NA and in Project Center I have a date, do you think that could have an impact on my final result?
Once again, I just have this issue for [Created[ for example, if I select [Start], everything works perfectly
