If function for children rows

Hi all,

I don't know how to build a formula for the following:

I want the parent row to show ''Pass'' when ''Pass'' is filled in for ALL children rows. If one or more of the children rows has ''Fail'' or ''Suspend'', I want the parent row to show ''Fail''. The children rows refer to the children rows of the parent cell.

Can anyone help me out?

Thanks in advance.



Best Answer


  • Thank you for taking the time to come up with a potential solution Giles! It's perfectly clear. I will use this as a workaround for now and keep my eye out for a cleaner solution.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!