Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

COUNTIF Does not equal

Lillian Murphy
edited 12/09/19 in Archived 2017 Posts

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!

 

Comments

  • Mike Wilday
    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

    with blank children.jpg

    withdata.jpg

This discussion has been closed.