Formula for Total Column

In our estimating sheet I'd like to have a locked formula that for parent rows it shows the sum of the children and on non-parent rows it shows the product of quantity*rate.

I'd like it to be one formula so that it can be locked on the column. Right now I have separate formula's that from time to time will be messed up and creates an issue.

Is this possible?


Answers

  • Leibel S
    Leibel S ✭✭✭✭✭✭

    Something like this:

    =IF(COUNT(CHILDREN()) > 0, SUM(CHILDREN()), Quantity@row * Rate@row)

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭

    If you have your formulas, just place them in the needed cells, then right click on the column header and select lock column. It will then lock the column from being able to be changed.

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!