Web Development

General discussion


MS Project - iif this can be done?

By mike ·
I want to create in MS Project a formula in a custom field to test for the existance of certain resources.

This works fine:
iif([Resource Names] = "Technician","Yes","No")

The problem is it will only pick up the resource if it is the only one. If Technician is allocated with another resource it ignores it. I cant use an OR as there are too many combinations. The iif does not seem to work with a wild card character (*).

Is there a way to do this?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

This can be done using InStr function

by ashisht In reply to MS Project - iif this can ...

InStr([Resource Names],"ResourceA")

This returns 1 if the ResourceA is any one of the resource names of that task, and returns 0 if its not present

Then you can apply another function to make 1="Yes" and 0="No"

Related Discussions

Related Forums