formulasgoogle sheetsgoogle-sheets-arrayformula
Here is what I am doing:
=IF('unique stock'!C11<=0,'unique stock'!C11,"")
and this goes on…
=IF('unique stock'!C22<=0,'unique stock'!C22,"")
=IF('unique stock'!C33<=0,'unique stock'!C33,"")
=IF('unique stock'!C44<=0,'unique stock'!C44,"")
Here, I am incrementing each cell by 11 rows manually. Please tell me if there is any way to increment rows by 11 dynamically for each cell.
You were pretty close. Here's a piece of code of which I think works:
function autoAddRows() {
var sh = SpreadsheetApp.getActiveSheet();
var cRow = sh.getActiveRange().getRowIndex(), mRow = sh.getMaxRows();
if((mRow-cRow) < 1) {
var lCol = sh.getLastColumn(), key = sh.getRange(mRow,lCol).getValue();
sh.insertRowAfter(mRow), sh.getRange(mRow+1,lCol).setValue(key+1);
}
}
var ss isn't necessary, since you don't use it in the script.getMaxRows)IF statement that need to be executed, when mRow-cRow=0I've prepared a file for you to experiment with: Inserting Rows + Reference
you could use a formula like:
=ARRAYFORMULA(FILTER(ROW(INDIRECT("A1:A20")), MOD(ROW(INDIRECT("A1:A20")), 2)=0))
A1:A20 represents range 1-202)=0 represents increment by 2
Best Answer
In excel you could use the following for a cell reference that would start at C11 and Jump by 11 for each row copied down:
You just need to substitute it into your equation.
I am not sure if Google Sheets performs the function in the same manner as excel.