Forum Discussion
Why isn't my formula working?
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)-COLU...
I don't use google sheets, but it appears it has a filter function. Perhaps try something like:
transpose(filter('Pick Your Meals'!E1:BIF2, 'Pick Your Meals'!E130:BIF130>0))
arrayformula(roundup(transpose(filter('Pick Your Meals'!E130:BIF130, 'Pick Your Meals'!E130:BIF130>0)), 0))
transpose(filter('Pick Your Meals'!E1:BIF2, 'Pick Your Meals'!E130:BIF130>0))
arrayformula(roundup(transpose(filter('Pick Your Meals'!E130:BIF130, 'Pick Your Meals'!E130:BIF130>0)), 0))