Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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
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.
Ok, please check if these values linked in are numbers or texts.
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?
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
You can also convert the text to a number using the VALUE() function.
Craig
