# Cant add look up columns to math column **URL:** \ **Category:** Ask for Help\ **Created:** [March 6, 2024, 2:27am UTC](https://community.glideapps.com/t/cant-add-look-up-columns-to-math-column/71448 "2024-03-06T02:27:52Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Pedrop](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pedrop/32/71433_2.png) [@Pedrop](https://community.glideapps.com/u/Pedrop)\ **Post date:** [March 6, 2024, 2:27am UTC](https://community.glideapps.com/t/cant-add-look-up-columns-to-math-column/71448/1 "2024-03-06T02:27:52Z")
Pretty much the title, I cant add 2 look up columns to one math column. I want to create a general dashboard. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 6, 2024, 3:14am UTC](https://community.glideapps.com/t/cant-add-look-up-columns-to-math-column/71448/2 "2024-03-06T03:14:25Z")
Are you trying to do this via a relation/query, or by directly targeting the Math columns? ---
**Author:** ![Pedrop](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pedrop/32/71433_2.png) [@Pedrop](https://community.glideapps.com/u/Pedrop)\ **Post date:** [March 6, 2024, 12:12pm UTC](https://community.glideapps.com/t/cant-add-look-up-columns-to-math-column/71448/3 "2024-03-06T12:12:16Z")
I’m trying to add the first and second columns to get a total result. ![IMG_4503](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/9/d9b2fa0d6972d68ed68d74d99a0594ff38847b18.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 6, 2024, 12:20pm UTC](https://community.glideapps.com/t/cant-add-look-up-columns-to-math-column/71448/4 "2024-03-06T12:20:22Z")
The values in those lookup columns are arrays, so you can’t add them directly. Do they come via a relation? If yes, then you should make the relation a _single_ relation, then you will be able to add them in a math column. ---
**Author:** ![Pedrop](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pedrop/32/71433_2.png) [@Pedrop](https://community.glideapps.com/u/Pedrop)\ **Post date:** [March 6, 2024, 6:38pm UTC](https://community.glideapps.com/t/cant-add-look-up-columns-to-math-column/71448/5 "2024-03-06T18:38:45Z")
I’m sorry but I’m a bit new to glide. What do you mean by coming via relation? They are rollups columns from other spreadsheets. ---
**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:** [March 7, 2024, 12:11am UTC](https://community.glideapps.com/t/cant-add-look-up-columns-to-math-column/71448/6 "2024-03-07T00:11:00Z")
In your screenshot, you’re showing two lookup columns that either is pointing to a whole column in another table, or is on top of a multiple relation. Do you mean to point it to a whole column, or should it be used in tandem with a relation? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 7, 2024, 12:55am UTC](https://community.glideapps.com/t/cant-add-look-up-columns-to-math-column/71448/7 "2024-03-07T00:55:20Z")
> [@Pedrop](#): > > They are rollups columns from other spreadsheets. No they are not. They are lookup columns. Do you mean that you are targeting a rollup column with a lookup column? It would be useful if you could show us how one of those lookup columns is configured, so we can get a better understanding of what you have. Regardless, you have two lookup columns that are both returning arrays (that’s what the bubble around the value means), and you cannot sum arrays. I’m guessing that you probably need to replace those lookup columns with Single Value columns, but I can’t say that for sure as I don’t know how they are currently configured or what they are referencing. ---
**Author:** ![Pedrop](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pedrop/32/71433_2.png) [@Pedrop](https://community.glideapps.com/u/Pedrop)\ **Post date:** [March 7, 2024, 1:31am UTC](https://community.glideapps.com/t/cant-add-look-up-columns-to-math-column/71448/8 "2024-03-07T01:31:22Z")
Look, i’ll try to be more clear. Each lookup columns are showing the values (relation?) of two different rollup columns. But these results are coming in as arrays, instead of just replicating the entire column. my objective is to just replicate the values of those rollup columns so I can add them together through the math column. ![IMG_4515](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e0c3571e050a0b7b4f23d137eef4cf5393391e88.jpeg) ![IMG_4517](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cbda7f88ba4627ce5be44fd93f14f3c196df9ae7.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 7, 2024, 1:40am UTC](https://community.glideapps.com/t/cant-add-look-up-columns-to-math-column/71448/9 "2024-03-07T01:40:05Z")
Okay, thank you. Here is one way to get what you want: - Use a Make Array column to create a Single Array from the two Lookup columns - Use a Rollup-\>Sum that targets the Make Array column ![CleanShot 2024-03-07 at 09.38.44@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/4/046b0596e064caffa9c24e7790fad6d95591d4f3.png) ---
**Author:** ![Pedrop](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pedrop/32/71433_2.png) [@Pedrop](https://community.glideapps.com/u/Pedrop)\ **Post date:** [March 7, 2024, 1:54am UTC](https://community.glideapps.com/t/cant-add-look-up-columns-to-math-column/71448/10 "2024-03-07T01:54:04Z")
Thank you very much, Darren and ThinhDinh! And sorry for the inconvenience. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 14, 2024, 1:54am UTC](https://community.glideapps.com/t/cant-add-look-up-columns-to-math-column/71448/11 "2024-03-14T01:54:05Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.