I am trying to develop a worfklow that writes a formula into a column with 30k lines with the following formula: “=RECHERCHEV(E5;‘SheetName’!F:F;1;0)”
Using the TypeInto activity is not an option!
This is the part of the workflow where I try to enter the formula:
However, when I run the robot this is the error message I’m receiving:
Anyone ever faced a similar problem related to writing an Excel formula and has some insight to how to solve this issue?
Obs: I am just trying to write on the F5 cell as a test. The final goal is to write on all the cells in the respective column.
Thanks in advance.