Multiply across columns, then sum children
I would like to use the sum children formula, however the calculation includes other columns before it can sum.
The month column contains number of units, while the cost of each unit is in another column. The sum for the month = #units * cost per unit. Can the children formula be used so that the formula doesn't have to be edited every time a new row is added?
Comments
-
I would suggest a helper column where you do the multiplication, then SUM that column using something along the lines of
=SUM(CHILDREN([Helper Column]@row))
-
Hi,
Probably! I'd be happy to take a look!
Can you share the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
We can play sum number games with this one (Haha).
=avg(children([Mar-2019]@row))*avg(children([Unit/Hour Cost]@row))*count(Children([Unit/Hour Cost]@row))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!