• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $149 (🏆Lifetime Access) - View offer

How to get relative reference Google Sheets formula to work?

Pabblynaut

Member
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 noABC
1Raindrops onRoses=CONCATENATE(A1,B1)
Pabbly adds row 2Whiskers onKittens=CONCATENATE(A2,B2)

How do I get Pabbly to add the right formula?
 

Supreme

Well-known member
Staff member
Hey @Pabblynaut

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

2023-06-27_12h00_12.png


Output -

1687847491705.png
 
Top