Children from a different column
I'm working on a stock inventory program for my company. The Parent row is the Running total, min/max barcode, description and so on. The Children will be the stock coming in and going out. I can on the Parent row Sum Children in IN column an then Sum Children in OUT column them have the formula in Parent Stock cell (IN@row - OUT@row) to have a running total.
What I want to do an can not get it to work is have formula in the Parent Stock column to sum the Children in IN column and OUT Column and then Subtract the two totals from each other. I have tried to just get the Parent Stock column to sum the Children in the IN Column. This is not working for me, I assume that I'm doing something incorrect and really hope that you do not tell me it not possible. Please help me if you can or if you have a suggestion for another way to clean it up a bit.
=CHILDREN([IN]) this is in cell STOCK 5
Answers
-
If you are already summing the children in the In and Out columns, you should be able to just reference those 2 columns on the parent row.
=In@row - Out@row
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!