Adding an IF statement to vSTACK

[thewiseguy]

Hello all - I am currently using this vSTACK formula:

=LET(v,VSTACK('ECM (BOM)'!B4#,'Labor Add. (BOM)'!B4#,'Project Level Items (BOM)'!B8:B19),FILTER(v,v<>""))

I would like to ammend the last statement (Project Level Items (BOM)'!B8:B19)) to stack the values in column B, ONLY if the values in column H are greater than 0.

Is this possible??

 

[RoryA]

You could change that part to:

FILTER('Project Level Items (BOM)'!B8:B19,'Project Level Items (BOM)'!H8:H19>0)

 

[thewiseguy]

You could change that part to:

FILTER('Project Level Items (BOM)'!B8:B19,'Project Level Items (BOM)'!H8:H19>0)

worked like a charm. thank you.