Trying to SUM( several specific cells from another sheet.

I am trying to link specific cells and SUM them up on another sheet, and do it for several rows, but it keeps changing all the cells to link to the same cells. 


  • ✭✭✭✭✭

    References can be a bit sketchy.. I ran into a scenario where I thought I was going to be smart and copy the text {January Metrics Range 4} , paste it and change it to {January Metrics Range 2} then change the reference...

    Smartsheet still sees that as the same range when it saves it.. so that may be why they all point to the same range

    Try building it slowly the long way using the edit reference button..

    I just tried it and it worked..

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!