Trying to enter a formula in a field of a parent row that will count children w/specific values

Emily Sanchez · 09/01/21

Hi all,

Fairly new to smartsheet and I am trying to set up a formula in a parent row with a single select drop down column "Status" that will count the children that show one of three specific values in the column:

So if the cell drop down choices in the Status column are:

Submitted

Interviewed

Offered

Declined

Withdrew

Hired

I want the cell in the parent row to count the children rows that have a value of either Submitted, Interviewed or Offered.

I have tried multiple combinations of the COUNTIF, COUNTIFS, CHILDREN functions but can only get it to count one status correctly. Whenever I try to tell it to count more than one I get #unparseable.

Can anyone assist?

Thanks!

Emily

Melissa Manzanera · 09/01/21

Hi Emily,

This is the formula I came up with, I placed it in the Blue Cell:

=COUNTIF(CHILDREN(), "Submitted") + COUNTIF(CHILDREN(), "Interviewed") + COUNTIF(CHILDREN(), "Offered")

Let me know if this is helpful,

-Melissa

Melissa Manzanera · 09/01/21

Hi Emily,

This is the formula I came up with, I placed it in the Blue Cell:

=COUNTIF(CHILDREN(), "Submitted") + COUNTIF(CHILDREN(), "Interviewed") + COUNTIF(CHILDREN(), "Offered")

Let me know if this is helpful,

-Melissa

Emily Sanchez · 09/01/21

That worked! Thank you so much! I think I was getting close but was definitely overthinking and trying too many functions-

Trying to enter a formula in a field of a parent row that will count children w/specific values

Best Answer

Answers

Help Article Resources

Categories