How can I insert a formula in a cell?

Question

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:

Answer 1

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