Forum Discussion
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 ...
If to check every field, not separate ones, that could be
=IF(SUMPRODUCT(--(LEN(Vendor_TBL[@[Full Name]:[Email]])<2)),TEXTJOIN(", ",1,IF(LEN(Vendor_TBL[@[Full Name]:[Email]])<2,Vendor_TBL[[#Headers],[Full Name]:[Email]],"")),"Ok")