IF Formula with Children
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.
Help Article Resources
Check out the Formula Handbook template!