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
email.zip (44.1 KB)

This is output i am getting as result finally
image

Hope it helps you

Regards
Nived N
Happy Automation

2 Likes

Thanks you bro.

1 Like

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