Project online formula not working

Copper Contributor

I am using Project Online with the desktop interface, and trying to set up a master project (comprised entirely of subprojects) with colour coded task bars by resource group.

I am using the Flag fields as widely suggested, but the simple formulas dont seem to pass the logic test and always show as "False".


What am I doing wrong?


Screenshot 2023-08-29 075501.png

5 Replies
WoollyGuy --

I believe the formula you need is:

IIF([Resource Group] = "Transportation", "Yes", "No")

Hope this helps.
Thanks for the quick reply. I tried the change that you suggest and the Flag field remains stubbornly unchanged at "No"

I am under the impression that the flag fields are an implicit Boolean test so the IIF is not required. But I'm still new at this so I could be mistaken and would appreciate any clarification
best response confirmed by WoollyGuy (Copper Contributor)
WoollyGuy --

In your original post, I cannot see the full name of the column that is partially hidden by the Formula dialog. Is the column the Resource Names column or the Resource Group column? If the partially hidden column is Resource Names, then the formula should be:

IIF([Resource Names] = "Transport", True, False)

I tested this formula using the Resource Names column, and it works as expected. Let us know and we will try to help you.

Since you are working with a master file (i.e. inserted subprojects only), the formula needs to be in the Flag field at subproject level, not at master level. It's important to understand that in a dynamic master, the subproject are not actually part of the master, rather, the master contains pointers to each individual subproject.

And yes, the implicit Boolean construct will work, I personally think it is bad practice.

Hope this helps.

@John-project Thank for the details- Removing the quotes from the True/ False argument was the issue.  appreciate the pointers on proper formatting as well... Im sure that will help me in the future when Im trying to remember what I did!