I want to create 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 can use an OR as there are too many combination. The iif does not seem to work with a wild card character (*).
Is there a way to do this?
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 can use an OR as there are too many combination. The iif does not seem to work with a wild card character (*).
Is there a way to do this?
