I am using the following formula:
=ARRAY_CONSTRAIN(ARRAYFORMULA(IFERROR(INDEX('Pick Your Meals'!$E$1:$BIF$1,SMALL(IF('Pick Your Meals'!$E$130:$BIF$130>0,COLUMN('Pick Your Meals'!$E$1:$BIF$1)-COLUMN($D$1)+1,""),ROWS($1:1))),"")), 1, 1)
What it should be doing is when the total cell on the sheet 'pick your meals' is populated with a number it returns the two header fields and total, if it's a zero in the total column it should return nothing, giving me a shopping list, see link below to doc, but it's returning random zero total columns.
https://docs.google.com/spreadsheets/d/1BQyDfeGVVpAmoGlloaQ2WYFc3ilOdOUHcJMZ8AvdhJ0/edit?usp=sharing
ROWS($1:1)since that is clearly and always one row, and it's being compared withSMALLto columns. Do you meanCOLUMNS($1:1)? Second, with numerous sheets as large as you have (all the way to column BIF) and trying to use individual complex formulas for every cell, you are virtually guaranteed to crash the system. Look into array formulas.