IF AND CHILDREN CONTAINS
I want to create a formula where if the children contains a status "Entregado Parcialmente" or "Sin entregar" to turn the parent row into "Entregado Parcialmente" ; otherwise if all the children contains or met the status "Terminado" turn the parent row into "Terminado", but if a cell doesn't contain anything I just want it to stay in blank.
I have made a formula but it doesn´t work, can somebody help me?. I would appreciate it a lot.
Help Article Resources
Check out the Formula Handbook template!