Formula for only Children rows but excludes Parent rows
Options
Comments
-
You might need 2 helper columns to identify parent or child rows. Then build your formula with a qualifier to check the helper row first before moving forward. We use these two:
Level - To identify what level down we are on
=IF(COUNT(CHILDREN([Task Name]@row)) > 0, COUNT(ANCESTORS()) + 1)
Task - To identify actual task or child rows
=IF(Level@row >= 1, 0, 1)
Task is a Checkbox column type. It will check the box if child. It would be easy enough to run a query against it first before doing your formula in whatever column you are using.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!