Detecting Sum formula "null" value
Hi Community
I have a simple sheet with a mixture of parent and child rows. Not all parent rows have child rows. I have a very simple formula [=SUM(CHILDREN())] to sum the value of child rows for a parent row where they exist. Where there are no child rows the formula returns a "0". I use conditional formatting to change the colour of a cell based on the value from the SUM formula. This works fine for any value returned other than the null value where there are no child rows. I want to change the text colour to the background of these "null" value cells so they appear blank rather than showing "0", but can't work out what the "0" returned actually is. I have tried all the variations in the conditional formatting options with no luck. Any one know what "value" is returned by my formula when there are no child rows?
Answers
-
Are you able to provide screenshots for context?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks for the follow up Paul - a weekend away of staring at it and the solution became obvious - fixed it first thing this morning in about 30 seconds 😂.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives