Forum Discussion
WoollyGuy
Aug 29, 2023Copper Contributor
Project online formula not working
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 fie...
- Aug 29, 2023WoollyGuy --
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.
WoollyGuy
Aug 29, 2023Copper Contributor
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
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
Aug 29, 2023
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.
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.