So I have a table in which i'm trying to add a check to see if any values in the last column of this table return a value of "FALSE" (it's worth mentioning that this "FALSE" is not strictly text - it's an IF formula result) . I'm using the CountIf formula but I can't seem to get it to work.
Here is my formula:
Here is an example of the table -
Column 1 Column 2 Column 3 Column 4
Name A 4/2/2018 4/3/2018 FALSE =IF(B2=C2,"TRUE","FALSE")
Name B 4/3/2018 4/3/2018 TRUE =IF(B3=C3,"TRUE","FALSE")
Name C 4/4/2018 4/4/2018 TRUE =IF(B4=C4,"TRUE","FALSE")
Here is my formula:
Code:
=IF(COUNTIF(Table_main[CHECK (GL Date)],"FALSE"),"YES","NO")
Here is an example of the table -
Column 1 Column 2 Column 3 Column 4
Name A 4/2/2018 4/3/2018 FALSE =IF(B2=C2,"TRUE","FALSE")
Name B 4/3/2018 4/3/2018 TRUE =IF(B3=C3,"TRUE","FALSE")
Name C 4/4/2018 4/4/2018 TRUE =IF(B4=C4,"TRUE","FALSE")
Last edited: