Is it possible to do a workflow that will find all of the instances of "11223 Facility" in the Default Labor Level and have it change the Organization to "Facilities" instead of Production? The Raw data is not quite in the format we need, so I would like it (if possible) to wholesale find and make the changes.
Solved! Go to Solution.
Hi @cwhitehead90
A formula tool can do this for you. Modify the existing organization field as follows:
IF [Default Labor Levels]="11223 Facility" THEN "Facilities" ELSE [Organization" ENDIF
Let me know if that helps
Cheers!
Esther
But with a closing square bracket instead of a quotation mark after Organization...
Thank you so much!