How to add a formula to a Google Sheets cell?


I try to add a formula to a Google Sheets cell.
I add =row() to the field value and if I run the node immediately, the formula is successfully added.
But if I save the workflow first, the “=” disappears.

The same is when I use a “Set” node.


If you can try this? {{ JSON.stringify(=row()) }}

I get “[invalid syntax]” when I add {{ JSON.stringify(=row()) }}

but I can use it so:
{{ JSON.stringify(‘=row()’).replace(/^.|.$/g,“”)}}

It’s not the prettiest solution, but it works☺️

Great! In my solution, I made a mistake. :slight_smile:

Thank you so much!

but there is a question how to add a formula like :

I get in my cell

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.