Issue writing formula into cell (Write cell activity)

[Daniel_Zarate (Daniel Zárate)]

Hi, I’m trying to write this formula
“=INDICE(‘MAESTRA BIEN’!$A$2:$G$2000;COINCIDIR(VALOR(EXTRAE(A2;4;10));‘MAESTRA BIEN’!$C$2:$C$2000;0);2)”

but I keep getting this error

Any idea of how I can solve this?

[Daniel_Zarate (Daniel Zárate)]

I’m working on it, solved it to some point but UiPath is putting “@” before the formula

[muhammedyuzuak]

Hi @Daniel_Zarate,

Do you get an error when you apply the formula manually?

@Daniel_Zarate

I’m working on it, solved it to some point but UiPath is putting “@” before the formula

You can check this post about it.

Value @ symbol question

Hi @atarantino , The @ sign simply tells us that its a String Text, nothing more or less i.e. its not a part of the string but just a representation. If it fails, there is a chance that there are some newlines/carriage returns in the variable, which can be easily eliminated using the Trim Method. Also, when you are assigning it to a filepath, you should also make sure to add an extra backslash like so → FolderPath+"\"+AplhaNumericBatch.Trim Could you give that a try and let us know? Also,…

Regards,
MY