Update new column with conditional formula

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.

CCO workflow.yxwz

Custom Tools

Interface Tools

Accepted answers

Amol_Telore

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')

Capture.PNG

All comments

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."

Export Workflow Pop-up.PNG

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.