Assigning Code base from No.

Question

Hi good day,Can anyone help on caculated column to achieved the below sample. Base from the code number.&nbsp;&nbsp;Output:Job No.ABSD234DFFGDABBF135RTERACFDG204NMBNABSD234RERWACFU232NMTIUOU135RTEERWE789WEWQACFD789NMBNACFD204HFTRRTEE890SDF&nbsp;Thank you

rajendraongole1 · Accepted Answer

Hi&nbsp;AllanBerces&nbsp;-Use below calculated column with switch and search function combination.&nbsp;JobCategory =SWITCH(&nbsp; &nbsp; TRUE(),&nbsp; &nbsp; SEARCH("234", [jobNo], 1, 0) &gt; 0, "Plumber",&nbsp; &nbsp; SEARCH("135", [jobNo], 1, 0) &gt; 0, "Mason",&nbsp; &nbsp; SEARCH("204", [jobNo], 1, 0) &gt; 0, "Electrician",&nbsp; &nbsp; SEARCH("232", [jobNo], 1, 0) &gt; 0, "Helper",&nbsp; &nbsp; SEARCH("789", [jobNo], 1, 0) &gt; 0, "Lead",&nbsp; &nbsp; SEARCH("890", [jobNo], 1, 0) &gt; 0, "Painter",&nbsp; &nbsp; "Unknown")&nbsp;&nbsp;It works please checkDid I answer your question? Mark my post as a solution! This will help others on the forum!Appreciate your Kudos!!&nbsp;

Forum Discussion

Assigning Code base from No.

2 Replies

Related content

Priority Based Sales Rep Assignment

Calculated column to assign numeric code to dates

assign each date to each code

Assigning Rotating Shift Teams based on Date

How to Assign Hex Code Based On Measure Value