Condtional Column on top of Conditional Column

[Anonymous]

I have this data:

So the 'Link ID' column is a conditional column based on this statement:

 

So for every record that has a Flex_M3_ID value, it replaces the Unique ID value which gave me exactly what I needed at the time.

I now have pulled in records with a Source System of Flex Pay M3.

For the Flex Pay M3 records, I need the value in the Link ID column to be replaced with the Legacy_ID__c field. How could I go about doing so? So for instance 145420 would need replaced with D5420, etc. etc.
 

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, you can refer to below steps:

Use the “Add Conditional Column” and set the conditions like the below picture and click the “OK”, you can see the correct result.

Regards,

Daniel He