Can I do a sum of numbers in an Array (split text) column? The roll up is counting items in array, not summing it. I found a almost 18 months old thread but couldn’t find the solution. [Screenshot 2023-02-19 053842]

var n = p1, remainder, sumOfDigits = 0; while(n) { remainder = n % 10; sumOfDigits = sumOfDigits + remainder; n = Math.floor(n/10); } return (sumOfDigits) put as p1 result from my first script

I assume the rollup column automatically reads the content of each array element from a split text column as text, so you wouldn’t be able to “sum” it. How did you generate the “FirstNameScore” column?

[image] Need help with writing a complicated google sheet formula on Glide tables Ask for Help sure… var x = [['A',1],['B',2],['C',3],['D',4],['E',5],['F',6],['G',7],['H',8],['I',9],['J',1],['K',2],['L',3],['M',4],['N',5],['O',6],['P',7],['Q',8],['R',9],['S',1],['T',2],['…

Why do you need that score to be split?

It’s part of the logic behind my game. :smile:

How do I write this in Math column? Is it going to give me the sum in array? Just for the reference here is the original formula used in google spreadsheet to calculate this value. Can’t figure out how to rewrite this in Glide. =ARRAY_CONSTRAIN(ARRAYFORMULA(IF(IF(LEN(C5)>1, SUM(IFERROR(MID(C5,ROW(…

Circling back to the solution there first. I would say you can do it like this: Convert the original string to all lowercase Split text on the lowercase string Use a unique array column to get only unique letters Use a relation + rollup combo to get the total

Through your javascript I calculated the score using the letters. Now the score for SanFrancisco came out to be 50 right? My next logic is to add all digits of the score. In this case I have to do a sum of 5 + 0.

what is the highest possible score?

Sum of numbers in array

Ask for Help

Hassan_Nadeem February 19, 2023, 1:17am 3

@ThinhDinh FirstnameScore column is computed using the JavaScript Uzo wrote

Topic		Replies	Views
How can I sum numbers in an array? Ask for Help	20	2908	November 12, 2021
Sum an Array Ask for Help	5	432	September 7, 2023
How to sum the array Elements in Glide? Ask for Help	7	635	October 28, 2023
Need help with writing a complicated google sheet formula on Glide tables Ask for Help	13	599	February 15, 2023
How can I calculate the total sum of row values in the sheet? Ask for Help	5	319	October 9, 2023

Sum of numbers in array

Related topics