Change cell value on column

Hi everyone.

I have datatable as Sheet1 table. I want to check if any item in “item” column is “no”… then it will change another which has same item from “ok” to “no”

The output as sheet2.

How to do that?

Thanks in advance!
Book1.xlsx (8.9 KB)

Hi @Mr.H

Check this workflow (44.1 KB)

This is output i am getting as result finally

Hope it helps you

Nived N
Happy Automation


Thanks you bro.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.