Web Development

Ask something
Discussion Locked

MS Project - iif this can be done?

0 helpful
1 reply

by mike 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

1 reply

by ashisht

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"

This discussion is closed to new replies.