|
'=ARRAYFORMULA(if(Row(A:A)=1,"Duplicate
Check",if(C:C="","",if(countif(C:C,C:C)>1,"Duplicate","")))) |
|
=ARRAYFORMULA(if(Row(A:A)=1,"Check for
Duplicates",If(B:B="","",if(countif(B:B,B:B)>1,"Duplicate",iferror(if(match(B:B,blist,0),"Bounced","NA")))))) |
|
=ARRAYFORMULA(if(Row(A:A)=1,"Send
NL #",if(C:C="","",VLOOKUP(C:C,schedule,3,false)))) |
|
=ARRAYFORMULA(if(Row(A:A)=1,"Sched
Date",if(C:C="","",VLOOKUP(C:C,schedule,5,false)))) |
|
="Pending to Sched:
"&counta(B3:B)-counta(C3:C) |
|
=ARRAYFORMULA(if(Row(A:A)=1,"Send
Tmpl
#",if(C:C="","",if(D:D="","NA",if(D:D=0,0,if(VLOOKUP(D:D,scheduled,3,false)="","NA",VLOOKUP(D:D,scheduled,3,false))))))) |
|
=if(E9=today(),match(E9,F9:BA9,0),"") |
|
'=if(OR(A3="",sum(F3:BA3)=0),"",
iferror(min(filter(F3:BA3,F3:BA3>=today())))) |
=if(P149="","",image(concatenate("http://drive.google.com/uc?export=view&id=",index(split(P149,"="),0,2))))
=IF(T150,T150,IF(U150="yes",NOW(),""))
=IF(COUNTIF(E9:E19,E9)>1,E9,"")
=IF(VALUE(RIGHT(G13,1))=0,"",1)
=LARGE(J6:J12,{1,2,3})
=SMALL(J6:J12,{1,2,3})
