I would like create a new sheet in my document and combine all values in Products sheet from column A (from A2) into one on the new sheet, when Current Stock (calculated) is greater than 1 (preferably only non blank cells):
Currently I am using formula:
=JOIN(";",Products!A2:A,"")
How can I add here check for Current Stock?
>Solution :
Try-
=JOIN(";",FILTER(Products!A2:A,Products!H2:H>0))
H2:H>0 will filter out non blank number values cells.
