How to specify a row has a specific parent in a function


I'm trying to average a collection of rows that fit a certain criteria.

So far, I have this formula and I know it works up until Job@row.

=AVG(COLLECT({DurationCPT},{CPTQ}, Job@row,{Packaging JobCPT},(PARENT("CMO")="Packaging Summary")))

For the rest of the formula, I am trying to full specific CMO rows that have "Packaging Summary" as its parent from my criterion range. Pic below:

Does anyone have any tips for this?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!