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.
Can someone help me? Thank you guys.