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..

Find more posts tagged with

Formulas

Comments

Jeremy C

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.

SharonR

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

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…