tobrien3’s Profile

Community member since March 2016

points
326

3

Hi Smartsheet community,

 

Trying to create a formula that counts the number of cells that are blank or have "No" in them.

 

It is a dropdown column with only two choices, "Yes" and "No", so I tried 

 

=COUNTIF([ColumnName]:[ColumnName], <> "Yes"), but that gives me 0