Hello everibody!
Is there any possibility of addition the numbers likes on the New column D on image?
How was that column created? Does the Rollup column on top of “New Column D” allow you to sum it?
If not, I guess it’s easier to just use JavaScript to act on the original column, which might be a comma-delimited list.
A rollup won’t work, because the source is a string.
So as @ThinhDinh suggested, the simplest approach is to use JavaScript:
return p1
.split(', ')
.map(num => Number(num))
.reduce((acc, num) => acc + num, 0);
2 Likes
Thank you very much for your help, I was never going to solve it.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.