I am new to MS Project (~1 week experience) and could use some help with an Enterprise Custom Field I'm trying to create. I'm using Project through Project Web App in Office 365 (I assume this is Project 2016?) and trying to create an Enterprise Custom Field at the Project level of type Text to calculate a Project Size based on Work. I have created the following formula in my custom field:
IIf([Work] > 1000, "XL", IIf([Work] > 160, "L", IIf([Work] > 40, "M", "S")))
Work is input at the Task level in Hours and is displayed at the Project level in Hours in my view in Project Center. My expectation is that the Work displayed at the project level is a sum of Work that has been input at the Task level for all tasks associated to the project and thus I should be able to use this formula to automatically populate my Project Size field. What I'm actually seeing is that some projects display nothing in Project Size (even though they have non-zero values for Work on tasks) and any project that actually displays a value always displays XL.
Am I missing something about how Enterprise Calculated Fields work in Project or is there something wrong in my formula syntax? Thanks in advance for any assistance.
Update: I added another calculated field (Numeric) that has a formula of [Work]. When I added it to my Project Center view, none of the projects had a value in this column. I went into a project for which I already had 1 placeholder task created and deleted the task. I then added the task back with the same information as the deleted task and saved/published it. After saving/publishing, the project still has no value in the Project Size column, however, my new calculated field is populated with the correct value of Work (in minutes as @Tom-Boyle stated). In addition, if I go back into the project and select Project Details from the left navigation, I do see a correctly calculated Project Size on that page.