Sheets add new row -> how to get rowindex of added row?

[Pabblynaut]

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

I use the Google Sheets add new row function. How do I get the rowindex of the new row? I need it, because I need to add a formula in a cell in that row, and I need the rowindex to make the formula correct.

Let´s say the newly added row is row 325. Now I want to get that number, so I can add the formula "=A325/12" in C325

 

[ArshilAhmad]

Hi @Pabblynaut,

It’s not possible to add the formula directly through the ‘Add New Row’ action step, as it only returns the row number in the response. However, you can use the ‘Update Cell Value’ action step in conjunction with the ‘Add New Row’ action step to achieve your use case. The ‘Add New Row’ step will give you the row number, which you can then extract and pass to the ‘Update Cell Value’ step to add the formula to the cell in column C.

Check out the workflow shared below:
https://connect.pabbly.com/workflow...KAz8KHlJWA1VWJV1EAAJXVFctUB1SKQ1IXW4LVVR8BWQ#

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support