Update new column with conditional formula

[Thiviya]

 Hi,

I am tyring to include the conditional formula and update the new column that I have created. with details. How do I do that.

As an example I have created new column "Tax Treatment", in this column I would like to have word " CCO" if the Master project ID column has the value such with CP numbers. 

[geraldo]

@Thiviya 

You could have exported your workflow with excel bases.
I couldn't understand what you want to do with the dynamic formula, its objective was not clear.,

[Prometheus]

@Thiviya To help us out, please go to the Options menu and click on "Export Workflow". 

After that, make sure all of your dataset check boxes are checked and your file location is where you want it, then click "Save."

You'll find your exported workflow in the location you chose. It will be a .yxzp file with a green icon. Upload that here so we can test your workflow and help you find a solution.

[Thiviya]

Thanks for the update. Attached the updated workflow.

Thanks

[Amol_Telore · Accepted solution]

Hi @Thiviya 

I have updated your formula a bit. I hope this is what you are looking for.

Formula: 

IIF(Contains([Master Project ID], 'CP'),'CCO','NA')

[Thiviya]

Thanks. That works. Really appreciated.