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

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?

Hey @Michael_Smith,

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

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


In the sheet itself, it then looks like this :

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

Hope that helps!


thank you, thank you, thank you!!