IF Formula with Children
Hello Everyone,
I am trying to figure out a formula that would show the children's status on the parent row. IF the children's "Status" column is "Completed" OR "Completed By Black Ops", the parent "Case Status" column should be "Completed", otherwise, "Pending"
Thank you in advance.
Tags:
Answers
-
Try something like this:
=IF(COUNTIFS(CHILDREN(), CONTAINS("Completed", @cell)) = COUNT(CHILDREN([Case Identification No.]@row)), "Completed", "Pending")
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!