How can I insert a formula in a cell in Automation Anywhere?
When I set the cell only with the value it throws me the following error:
I have the following:
I don't think you can set the current active cell using Set value and insert a function. Pretty annoying. I have used something like an offset transaction counter and offload your set value to like Z$vCounter$, store the value, and reassign it back to whatever cell you wanted to originally set the value of.
This is a very brief example https://i.gyazo.com/de73a60d7f177a26c71cc2e01ed862a4.png