= formula to + only the values in parental row

Flavio Tincani

Hi, I need help to put a formalua that will only + the values of the parental row in my helper column

I have example below, I need to convert the "Helper Need" column to a formula column but that will only + the values in the parental row... I don't want the "Helper Don't" to happen (which is happening right now if I convert to the column formula)

The formula I'm using right now is a simple "=Element@row + Size@row + Class@row"

Andrée Starå

Hi @Flavio Tincani

I hope you're well and safe!

Not sure I follow! What do you want the Helper Need column to show? Can you write out an example?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Flavio Tincani

Hi Andrée, thanks for your rapid response! Hope you are having a nice day!

I need the "Helper Need" to show exactly what is in there, the "+" of Element, Size and Class... so in case of the first row "WaterBigGood"

The problem I'm having is when I turn that column in a formula column the "Helper Don't" happens, and I don't want the "+" of the children row to happen...

Not sure if I was clear, please let me know if you need more info

Flavio Tincani

I tried something here but it counted the other way around lol, need to count only the parental row

Flavio Tincani

The "parental row" I mean would be the ones that have "Water", "Fire" and "Earth"

Andrée Starå

@Flavio Tincani

Happy to help!

Try something like this.

=IF(COUNT(CHILDREN(Element@row)) > 0, JOIN(Element@row:Class@row))

Did that work=

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Flavio Tincani

Hi Andreé, it worked!

I Just replaced the "Join(A:B)" to =IF(COUNT(CHILDREN(Element@row)) > 0, A+B) because sometimes I have columns that I need "+" and are not next to each other

Thanks a lot!

Cheers,

-

F

Andrée Starå

@Flavio Tincani

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!