Help with my formula
I am not the best at formulas and need some help. I cant seem to get my head around building formulas. Anyway can someone help please.
I am trying to build a formula that will
count all the true BOOLEAN in the children row and when it is greater than 4 return the a true outcome to the parent row.
Hoopefully someone can make sense of this... Please help..
Comments
-
Sharon - I'm currently using this simple sumif in one of my sheets on the parent row. You could modify this to be:
=SUMIF(CHILDREN(), >4)
I'm not sure about the boolean count but it sounds like you may need an IF statement with the SUMIF nested inside of it.
Hope this gets you started.
Regards - JC
-
Thanks for you help, yeah i have already tried that sum and variation to it. But i think this formula is quite hard.
I am trying to get a high level view of an outcomes on my sheet, so on the parent line i am showing the current status of the children line, once the goal is reach we can stop counting
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!