Sum of Children not working

Hollie205

I have 1 Sum of Children formula not working and can't figure out why it isn't working. Here are some screenshots. What am I missing. It keeps giving me $0 where the formula is and should be giving 182.16

Paul Newcome

Exactly how is the source data being populated? It sounds to me like it is coming across as text values.

Hollie205

I finally got it to work. It must have been a glitch in smart sheets. All I did was remove the hierarchy and re-add it and it started populating correctly

Paul Newcome

Glad it is working for you now.

I have been having intermittent issues with hierarchy the past couple of days as well.