Google Sheets Dynamic Column Reference

When I have an UPDATE ROW module that inserts formulas into cells that reference other columns in that sheet.
While I can insert a [dynamic] rowNumber reference by using the row number reference from a previous module, I wind up hard-coding in the column reference.
This isn’t typically a problem, unless in my google sheet I want to insert a column, and therefore bump all the columns over to the right. This then throws off my hardcoded column references which don’t understand that used to be column AP is now column AQ



Is there anyway to be able to insert columns directly in google sheets, without it throwing off my Make automation, and without me coming back into make and re-writing all of my hard-coded column references?

1 Like

I recorded a short screen-sharing video to explain the resolution.

Watch here: Loom | Free Screen & Video Recording Software | Loom

Let me know should you have any further questions and do not hesitate to reach out to us for help anytime.

1 Like