jeudi 17 octobre 2019

How do I add conditions with Arrayformula to hide lines when there is no data?

I have a column that pulls data from multiple cells to form an event description. But I would like to add some conditions to hide stuff with " " that doesn't have any information in the cell. I am not sure how can I use an IF condition within an IF within an Array formula.

=ArrayFormula(
IF(ROW(AR:AR)=1,"Description", 
IF(ISBLANK(AR:AR),"", 
IF(LEN(A:A),"Supplier 
"&I:I&" - "&J:J&" : "&K:K&""&L:L&"MT 
"&M:M&" - "&N:N&" : "&O:O&""&P:P&"MT //Hide "-"  ":" "MT" or the entire line if there is no 2nd Supplier
"&Q:Q&" - "&R:R&" : "&S:S&""&T:T&"MT //Hide "-"  ":" "MT" or the entire line if there is no 3rd Supplier

Remarks "&U:U&" //Hide the entire line if there are no remarks

Agent "&W:W&" "&X:X&" "&Y:Y&" 

Lab "&V:V,""
))))

Currently the result below where there are no 2nd & 3rd supplier is not very ideal.

Supplier 
CHEVRON - 12345678 : AAE500CST1900MT
 -  : MT
 -  : MT

Remarks 

Agent Avenger Steven 88888888 

Lab 

Aucun commentaire:

Enregistrer un commentaire