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 Make.com 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
=if(AP{{3.rowNumber}}>0,AP{{3.rowNumber}}-AN{{3.rowNumber}},“”)
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?