Filter only children row when certain criteria is met.

Hello Community,

What I am trying to do here is to display the milestones achieved by each client. The milestones are contained in children rows. The way to identify those milestones would be displaying the row with the highest date within its own family group and box check checked.

Once I am able to filter the rows that meet such criteria, I will display them in a dashboard using a widget chart

So far I am getting #UNPARSEABLE errors with all I have tried;

=COUNTIFS(CHILDREN([Complete?]@row), =1, & ([Date]@row),= ISDATE())

Thanks in advance for your help to this newbie.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!