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?

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

Katie

Try
=COUNTIF(CHILDREN(), "")

0 · Share on Facebook Share on Twitter
Katie McDonald ✭

09/23/16

OMG!!! I thought I tried that... Thank You!!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day