multiplication question
adminISI
✭✭
Hello,
I need to do two things.
- Multiply the Qty Shipped by the Unit Price for the indented rows.
- have the total in the outdent.
Thank you
Answers
-
Hi
I would add a helper column and do the multiplication in there.
=[Qty Shipped]@row * [Unit Price]@row
You can make this a column formula and hide the helper column so it is not visible.
Then you can SUM the children rows of that helper column. The sum would be
=SUM(CHILDREN([Total Price]@row))
where Total Price is the name of your helper column, created in step 1.
Does that make sense?
-
Yes, thank you very much. That was helpful.
-
Great, glad I could help! I just edited my comment to put a screen shot in, which will make it clearer for anyone else wanting to do the same thing.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives