when the robot writes a formula in excel, does the formula show #name?? So you need to click on the cell to show the result, does anyone know how I can write the formula without having to click on the cell afterwards? My excel is in Portuguese
did you try the “Write cell” activity?
Something like this:
yes, i’m using write cell, write in excel without a problem, but the result appears as below:
But, the robot is writing correctly, because when I click on the cell, it updates and the correct value appears, but I would like it not to be necessary to click, because the robot writes in several different columns.
What is the formula you are writing?
usually, Excel returns #NAME? when the formula is not correct. So maybe the formula is wrong.