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.

How can I count just Blank child cells?

Options

Katie McDonald

Katie McDonald ✭

09/22/16 edited 12/09/19 in Archived 2016 Posts

I can make the formula work if the cell has a number in it but not if it is blank! I've nested IF statements until I'm blue!!!

0 ·

Comments

JamesR ✭✭✭✭✭✭

09/23/16
Options
Katie

Try
=COUNTIF(CHILDREN(), "")

0 · Share on Facebook Share on Twitter
Katie McDonald ✭

09/23/16
Options
OMG!!! I thought I tried that... Thank You!!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

% Complete is Incorrect
In project settings I have dependencies enabled. This auto calculates % complete; however, the. percentage is incorrect. In my example I have 2 Parent rows, each with 5 tasks. Everything under Parent 1 is complete and everything under Parent 2 is not started. The % complete should be 50%; however it shows 43% complete. I…
Index-Match cross-sheet reference for a Contact List column
Hello everyone - thank you for your help. I am having some challenges with an Index/Match formula that populates a Contact List type column from a cross-sheet reference. It is finding the data & pulling it back, but it is not formatting the column as a "contact" - it looks like plain text (no contact "circle") This is my…
Reference sheet CountIf Contains
Hello, I am trying to build a reference sheet that gives a summary of quarterly results. I need to count the row if the value contains either Exception or Samples. I tried many different versions only getting many different error messages. This is my last attempt getting a Invalid Operation. =COUNTIF({2023 Q4 Monitoring},…