Find and Change

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.

Help

Accepted answers

estherb47

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

All comments

estherb47

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703