i am trying to automatically update a formula each time a new row is added. For the columns that have a simple formula arrayformula works well, but some of the columns have a larger formula which contains larger formulas like column L2 which has the following =NOT(OR(L$1>$F2,EOMONTH(L$1,0)<$E2))*(MIN(EOMONTH(L$1,0)+1,$F2)-MAX(L$1,$E2)) the formula does not work
I have attached the sample google sheet for your reference. i woul like column L to automatically update when a new row is added
Bookmarks