SUMIF with CHILDREN

Working on a formula within a sheet where I am trying to sum estimate amounts based on their % closed. I have 2 categories we have created using children/parent (indenting) I want to only count the projects that are within 1 category. My formula is

=SUMIF(CHILDREN({A LEADS}), ({% CLOSE}=25%), CHILDREN({Amount})


This keeps coming back #unparsable. Any thoughts?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!