Count if formula for deliverables

I was wondering if someone could help me with putting a formula together. I created a formula to count how many deliverables where completed if my received column was checked. ="Completed Deliverables: " + COUNTIF(CHILDREN(Received33), 1) + " of " + ((COUNTIF(CHILDREN(Received33), 1) + (COUNTIF(CHILDREN(Received33), 0))))


However for my Caremount Project Plan I would like in the details column to have for next to each milestone count completed deliverables out of total deliverables based on the % column. If the task is marked as a deliverable under the program status and it is 100% complete then count that out of the total amount of deliverables for that milestone.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!