Apply a google sheet formula to a new row relatively so the row letter updates

Questions & Answers
1

I have a new row created in a google sheet. I’d like to copy a formula in one column to the new row like when you drag-copy in sheets and the formula is updated relatively so the formula applies to the new row. Is this possible?

2

Hey @Michael_Smith,

It is possible, by using the indirect() functions.

Here’s an example of a scenario I have in Make:
image

={{3.data.data.total_karma}}-indirect("C"&row()-1)

In the sheet itself, it then looks like this :
image

So by using the indirect function you can create ‘dynamic’ references to other cells, just like the dragdown functionality would do.

Hope that helps!

2 Likes
3

thank you, thank you, thank you!!

4