Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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!
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
