How to conditionally format based on sum of children?


I currently have a meeting agenda sheet. In the parent row for the meeting I'm calculating how many meetings have been reserved for the meeting versus how many have been put on as agenda items. In the parent row I have a formula:

="60 minutes have been reserved for the meeting and " + SUM(CHILDREN()) + " minutes have been put on the agenda."

How could I maybe just put "60" in the parent cell indicating the total number of minutes, and then use condititional formatting so that IF the sum of the children agenda minutes requested is greater than the time alloted for the meeting it would flag the parent "60" to give me a visual indicator the agenda is already over time?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!