Apr 27 2021 08:33 AM
I am looking to put in and 'if' formula (or similar).
This formula is based on all rows of a table, over two columns.
The formula should give a result of Yes or No (or similar).
The check should be that if all 'Trues' in the 'delivered' column, have a name recorded next to it in the 'Signed By' column, Then Yes, if Not No.
Apr 27 2021 08:42 AM
Shouldn't the result in your sample workbook be FALSE/No/0 since there is a row with TRUE in the delivered column but no name in the Signed By column?
If so, you can use
=COUNTIFS(Table1[Delivered],TRUE,Table1[Signed By],"")=0