Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

SUM of linked values

Options
Trym Dahl
Trym Dahl
edited 12/09/19 in Archived 2016 Posts

Hello,

How do i create a SUM of linked values from other sheets?

If i break the links and add a numeric value the SUM-formula works.

 

Best regards

 

 

 

sum smartsheet.PNG

Comments

  • Atus Bartal
    Atus Bartal ✭✭✭✭✭✭
    Options

    Trym,

    If you have a formula like this in "SUM: "row:

    =SUM(Values1:Values4)    ['Values' is the column name]

    then you will get the right value (7 in this case). It doesn't matter that the values in the first 4 rows are linked in from other sheet(s).

     

    I hope this helps.

     

    Atus 

     

  • Trym Dahl
    Options

    Hi Atus,

    Ill send you a printscreen and the formula:

     

    =SUM([Har hanterats checklista för What ToDo]1:[Har hanterats checklista för What ToDo]66)

     

     

    Still doesent work.

     

    Best regards

    sum smartsheet 2.PNG

  • Atus Bartal
    Atus Bartal ✭✭✭✭✭✭
    Options

    Ok, please check if these values linked in are numbers or texts. 

  • Trym Dahl
    Trym Dahl
    edited 07/14/16
    Options

    In the sub-sheets, its checkboxes - handled/not handled per row.

    At the bottom of this checkbox-column there is a countif-formula:

     

    =COUNTIF([Har hanterats checklista för "What ToDo"]1:[Har hanterats checklista för "What ToDo"]8, 1) + ""

     

    This countif-cell is linked into a master-sheet as seen above with 7/0/0/0 that i try to SUM at the bottom of the column.

     

    Was the an answer to you question? 

  • Atus Bartal
    Atus Bartal ✭✭✭✭✭✭
    Options

    Yes, thanks. 

    + "" is the answer at the end of the formula. I understand that this is the way a checkbox column accepts string/text values, but they just seem to be numbers, and cannot be totalled.

    If you would like to make calculations with these values, I would suggest to have another column for the COUNTIF formulae (without + "")

     

    Hope this helps

     

    Atus

     

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    You can also convert the text to a number using the VALUE() function.

     

    Craig

This discussion has been closed.