Parent Flagging based on Child Rows
Dakota Haeffner
✭✭✭✭✭
Hello,
I'm working in a project planning trying to highlight if a specific row, or project, has any task as children that is at risk. Does any syntax support this function?
Tags:
Answers
-
Hi Dakota,
Try this formula in the parent row :
=CONTAINS("true", JOIN(CHILDREN()))
Hope it works for you.
Gia Thinh Technology - Smartsheet Solution Partner.
Email : thinh.huynh@giathinh.tech
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!