Writing formula to cell

Help Studio
1

Hi guys, I am struggling with this problem: when I trying to write formula to cell using Write cell function, an error pops up:

Write Cell: The data you want to write “=IFERROR(IF(MATCH(B(x+1),B(x+2):B200,0),”“”“In Process”“”“),”“”“Completed”“”“)” has a wrong format, or Excel is busy. If your data is a formula, make sure you use comma as parameters separator. Please check that you are not editing a value and that no dialog windows are opened.

my formula works well in excel which is =IFERROR(IF(MATCH(B2,B3:B200,0),“In Process”),“Completed”).

I am trying to use while loop in the workflow in order to automatically write this formula to every row which exists value.

image

Can someone help me? Thank you guys.

1 Like
2

Hi @Chili_Chan Welcome to our UiPath Community
You are using many double quotes just use as below
“=IFERROR(IF(MATCH(B2,B3:B200,0),”“In Process”“),”“Completed”“)”

2 Likes
3

Thanks guy, it works!

1 Like
4

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