# Conditional count of parents rows only with now children on a date column.

✭✭

Help!

I have this formula on a different sheet that works when I am counting the dates in the column. However, I want to count only the parent deliverables, not the children’s tasks. Can someone please help me?

=COUNTIFS({CC Label Activities}, AND(@cell >= DATE(year@row, [Month1]@row, 1), @cell <= DATE(year@row, [Month1]@row, 31)))

Sample Data Sheet

Sample Formula sheet

Thank you!

• Employee

Ah my apologies! I skipped over the AND in your COUNTIFS. You don't need this as the COUNTIFS is already an AND statement.

Try:

=COUNTIFS({Date Logged}, <> "", {CC Label Activities}, >= DATE(year@row, [Month1]@row, 1), {CC Label Activities}, <= DATE(year@row, [Month1]@row, 31))

Let me know if this gives you an error or incorrect result.

October 8 - 10, Seattle, WA | Register now

• Employee

Since we removed the AND(), you only need 2 )) at the end of the formula. Try removing out one of the ) and see if that helps. 🙂

October 8 - 10, Seattle, WA | Register now

• Employee

You can filter out Child Rows as long as your source sheet has something that indicates if the row is a Child or Parent.

From what I can see in your screen capture, only Parent rows have a date in the "Date Logged" column, is that correct? If so, you can add criteria that says that cell needs to be <> "" or Not Blank:

=COUNTIFS({Date Logged Column}, <> "", {CC Label Activities}, AND(@cell >= DATE(year@row, [Month1]@row, 1), @cell <= DATE(year@row, [Month1]@row, 31)))

Cheers,

Genevieve

October 8 - 10, Seattle, WA | Register now

• ✭✭

Thank you for being so helpful.

Thank you!

• Employee

Ah my apologies! I skipped over the AND in your COUNTIFS. You don't need this as the COUNTIFS is already an AND statement.

Try:

=COUNTIFS({Date Logged}, <> "", {CC Label Activities}, >= DATE(year@row, [Month1]@row, 1), {CC Label Activities}, <= DATE(year@row, [Month1]@row, 31))

Let me know if this gives you an error or incorrect result.

October 8 - 10, Seattle, WA | Register now

• ✭✭

Sorry but I am getting the error below. I tried to play around with it, but I still get errors.

• Employee

Since we removed the AND(), you only need 2 )) at the end of the formula. Try removing out one of the ) and see if that helps. 🙂

October 8 - 10, Seattle, WA | Register now

• ✭✭
edited 12/05/23

Thanks a million for your help! I appreciate it!

It worked! 😂

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!