Replacing Value in a separate column based on certain conditions

Hello All,

How do i replace value in a column based on a different conditions,

Example: In case of Department Type called Sales and PO value called NO and No value in a separate column, How do i replace it as NA instead of NO?

i have attached example of my data, Your help will be highly appreciated.

Datasets

Accepted answers

See WF appended and modified with your requests.

NEW Wf.PNG Multi-Row Formula.PNG

Cheers,

Solution (1).yxmd

All comments

Hi @Mostafa_Anwar

I'm not sure if I understood you well, but this is the solution that I thought.

WF appended.

Cheers,

Thanks @Thableaus for your reply, Your solution will change the all value in all rows in case of the value NO, Sorry let me clarify more, I want only the value against PO in case of NO to be changed to NA not for all.

As per the example below to change NO value against PO field only.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703