COUNTIF(CHILDREN() Formula Assistance

The following works for my sheet but I'm unsure how to write it so that if there are no child rows, it will say "No Submission Received".

=IF(COUNTIF(CHILDREN(), OR(@cell = "Facilities Readiness", @cell = "Workspace Navigation and Signage")) = 2, "Final Approved", "Partially Approved")

Appreciate any assistance!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!