How to get relative reference Google Sheets formula to work?

Status: Closed · Asked by Pabblynaut on · 0 views

Pabblynaut — Question ·

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?

Pabblymember11 — Reply ·

Hey @Pabblynaut

Please refer to the following screenshot if you want to add a formula in Google Sheets action step.

Output -

Back to all forum threads · Log in to reply