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
-
I would insert a helper column (flag type that can be hidden after setting up) and then use this formula:
=IF(VALUE(LEFT([Text String Column Name]@row, FIND(" ", [Text String Column Name]@row) - 1))< SUM(CHILDREN([Minutes Column Name]@row)), 1)
Then you can set up your conditional formatting based on this new column being flagged.
Answers
-
I would insert a helper column (flag type that can be hidden after setting up) and then use this formula:
=IF(VALUE(LEFT([Text String Column Name]@row, FIND(" ", [Text String Column Name]@row) - 1))< SUM(CHILDREN([Minutes Column Name]@row)), 1)
Then you can set up your conditional formatting based on this new column being flagged.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!