Find and Change

[cwhitehead90]

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.

[estherb47 · Accepted 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

[PhilipMannering]

But with a closing square bracket instead of a quotation mark after Organization...

[cwhitehead90]

Thank you so much!