Forum Discussion

Brass Contributor

Mar 02, 2020

Avoiding a SPILL Error

Hello, I have a spreadsheet containing a table where each row is a separate vendor. On the far right I have a column that checks various fields to make sure they are filled in properly and results ...

excel

Formulas and Functions

office 365

SergeiBaklan

Diamond Contributor

Mar 02, 2020

JBF_54

There is no spill error with structured references

=IF(TEXTJOIN("
",TRUE,IF([@[Full Name]]="","Missing Full Name",""),IF([@Company]="","Missing Company Name",""),IF(AND([@[Mobile Phone]]="",[@[Business Phone]]=""),"Missing Phone Number",""),IF([@[Business Address]]="","Missing Address",""),IF([@Email]="","Missing Email",""))="","OK",
TEXTJOIN("",TRUE,IF([@[Full Name]]="","Missing Full Name",""),IF([@Company]="","Missing Company Name",""),IF(AND([@[Mobile Phone]]="",[@[Business Phone]]=""),"Missing Phone Number",""),IF([@[Business Address]]="","Missing Address",""),IF([@Email]="","Missing Email","")))

If inform what exactly was missed then compare field by field