Help Please!!
I'm trying to populate a text field with a designated number from a precise naming convention.
An example of the formula I have been using is:
IIf(InStr([Name],"Prod Eng K.O")>0,"002","")
The problem I have is that if I have another task with the Name "Prod Eng K.O 2" then...