# Rollup in one sheet recognize one Math column in another as a string

**URL:** <https://community.glideapps.com/t/rollup-in-one-sheet-recognize-one-math-column-in-another-as-a-string/26858>\
**Category:** Ask for Help\
**Created:** [May 16, 2021, 7:19pm UTC](https://community.glideapps.com/t/rollup-in-one-sheet-recognize-one-math-column-in-another-as-a-string/26858 "2021-05-16T19:19:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![emiliano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emiliano/32/26371_2.png) [@emiliano](https://community.glideapps.com/u/emiliano)\
**Post date:** [May 16, 2021, 7:19pm UTC](https://community.glideapps.com/t/rollup-in-one-sheet-recognize-one-math-column-in-another-as-a-string/26858/1 "2021-05-16T19:19:40Z")

</div>

Hey!

I’m building an expense splitter, so I have some users in a table, and some expenses in another.

I perform some calculations to split the expenses the way I want in the expenses sheet, so I have several ‘Math’ columns there. Then, in the users sheet, I did a relation between them and the expenses, and now I’m trying to sum it all with a Rollup column, to see the ‘total’ someone is owing. The problem here is that there are some ‘Math’ columns that I can sum normally, but some that I can’t. It’s only showing ‘Count’ and ‘Count Unique’ as an option. I guess it’s being recognized as a String, but I don’t know why.

Any ideas?

Thank you!

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [May 16, 2021, 8:40pm UTC](https://community.glideapps.com/t/rollup-in-one-sheet-recognize-one-math-column-in-another-as-a-string/26858/2 "2021-05-16T20:40:07Z")

</div>

Hey! Make sure every column in expenses sheet are number column

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 16, 2021, 10:45pm UTC](https://community.glideapps.com/t/rollup-in-one-sheet-recognize-one-math-column-in-another-as-a-string/26858/3 "2021-05-16T22:45:08Z")

</div>

Adding to what Lucas said, do you happen to have empty values in those columns?

---

<div class="post-metadata">

**Author:** ![emiliano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emiliano/32/26371_2.png) [@emiliano](https://community.glideapps.com/u/emiliano)\
**Post date:** [May 16, 2021, 11:14pm UTC](https://community.glideapps.com/t/rollup-in-one-sheet-recognize-one-math-column-in-another-as-a-string/26858/4 "2021-05-16T23:14:09Z")

</div>

Thank you, @Lucas_Pires and @ThinhDinh! Indeed, as the Math Column was getting the results from an If column, all of them that were filled were numbers, but some were empty. Adding an ‘else’ with a ‘0’ solved it.

Thank you!

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/rollup-in-one-sheet-recognize-one-math-column-in-another-as-a-string/26858/5 "2024-01-17T16:52:08Z")

</div>