Trying to enter a formula in a field of a parent row that will count children w/specific values
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
Best Answer
-
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
Answers
-
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
-
That worked! Thank you so much! I think I was getting close but was definitely overthinking and trying too many functions-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!