COUNTIF Does not equal

Lillian Murphy

Hello!  I'd like to set up a formula to COUNTIF(Children)<>"app/registration complete"  so I don't have to setup a more complicated COUNTIFS (I allow the dropdown to not be restricted to the text options I set up).  Can't seem to get it to work.  Is "does not equal" possible for COUNTIF in Smartsheet?  Thanks in advance!

 

Mike Wilday

Hi Lillian, 

Try this. The formula you were putting in your post does is not complete. According to the Countif function, you have to put a range, and a comma, then the criteria for your Countif. 

=COUNTIF(CHILDREN(), <>"app/registration complete") 

One thing you should be aware of is, if the children of the column you are adding this formula to are blank it will count 0. So make sure your children have an initial value of something.

See the screenshots below to see what I am talking about.

See here for more: https://help.smartsheet.com/function/countif