Excel dropdown update

Help Activities
, ,
1

Hi, I have a use case
image
where it should update “Status” column with Yes if “Number” column value is 1
and no if “Number” column value is 2 and done if value is 3.

how can I automate this.

TIA

2

Hey @MEGHA_cs ,
I have built a sample workflow you can refer this
Test22.zip (2.0 KB)

image
image636×613 17.6 KB

image

Hope this helps

3

Thanks…
but the values in column Number are dynamic, and cannot hardcode as yes, no or done…
if number is 1 then it should select 1st item from “Status” column…

4

@MEGHA_cs ,
I believe your Conditions are only three that is if Number is
1 then “Yes”
2 then “no”
3 then “done”
is it Correct ?
If not can you share the Sample input excel?

5

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