How to get relative reference Google Sheets formula to work?

[Pabblynaut]

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?

Row no	A	B	C
1	Raindrops on	Roses	=CONCATENATE(A1,B1)
Pabbly adds row 2	Whiskers on	Kittens	=CONCATENATE(A2,B2)

How do I get Pabbly to add the right formula?

 

[Pabblymember11]

Hey @Pabblynaut

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

Output -