How to get relative reference Google Sheets formula to work?
Status: Closed · Asked by Pabblynaut on · 0 views
I have a google sheet with a formula to concatenate 2 cells.
ROW C:
=CONCATENATE(A1,B1)
How can I use Pabbly to add new data, but also have the formula added and working?
[TABLE]
[TR]
[TD]Row no[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Raindrops on[/TD]
[TD]Roses[/TD]
[TD]=CONCATENATE(A1,B1)[/TD]
[/TR]
[TR]
[TD]Pabbly adds row 2[/TD]
[TD]Whiskers on[/TD]
[TD]Kittens[/TD]
[TD]=CONCATENATE(A2,B2)[/TD]
[/TR]
[/TABLE]
How do I get Pabbly to add the right formula?
Hey @Pabblynaut
Please refer to the following screenshot if you want to add a formula in Google Sheets action step.

Output -
