multiplication question

adminISI
adminISI ✭✭
edited 11/13/23 in Smartsheet Basics

Hello,

I need to do two things.

  1. Multiply the Qty Shipped by the Unit Price for the indented rows.
  2. have the total in the outdent.

Thank you


Answers

  • KPH
    KPH ✭✭✭✭✭✭
    edited 11/13/23

    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.

  • KPH
    KPH ✭✭✭✭✭✭

    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.