# How can I perform a calculation with data from another sheet
**URL:** https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294
**Category:** Ask for Help
**Created:** [December 23, 2021, 6:09pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294 "2021-12-23T18:09:13Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)
#### Post date: [December 23, 2021, 6:09pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/1 "2021-12-23T18:09:13Z")
How can i perform this calculation?
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 23, 2021, 7:20pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/2 "2021-12-23T19:20:50Z")
use relation and lookup columns to bring values from another sheets, then just math column to calculate
---
### Author:  [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)
#### Post date: [December 23, 2021, 7:39pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/3 "2021-12-23T19:39:23Z")
So this i have done. what is wrong???
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [December 23, 2021, 7:47pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/4 "2021-12-23T19:47:42Z")
Add a new ‘lookup’ column to the sheet from this 👆screenshot.
Use your relation ingredient and choose the appropriate column.
Now you should be able to use that new lookup to finish your math template.
---
### Author:  [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)
#### Post date: [December 23, 2021, 7:51pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/5 "2021-12-23T19:51:35Z")
You can see them here. But not in the calculation.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 23, 2021, 7:58pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/6 "2021-12-23T19:58:44Z")
add a lookup column for this relation, to get values that you need from that sheet
---
### Author:  [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)
#### Post date: [December 23, 2021, 8:08pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/7 "2021-12-23T20:08:32Z")
I still can’t see them
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 23, 2021, 8:13pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/8 "2021-12-23T20:13:45Z")
Are the source columns are in number format? I see you have a blank cells there… that will format column to the text… make sure to replace blanks with zeros before
---
### Author:  [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)
#### Post date: [December 23, 2021, 8:26pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/9 "2021-12-23T20:26:33Z")
It said Fuje apple instead of Apple Fuji
---
### Author:  [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)
#### Post date: [December 23, 2021, 8:28pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/10 "2021-12-23T20:28:51Z")
If I make a lookup copy of a number, is this copy automatically also a number?
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 23, 2021, 8:53pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/11 "2021-12-23T20:53:34Z")
Only if whole column are numbers… you have empty rows there , that’s why is not converting to numbers, use if empty then zero column before lookup
---
### Author:  [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)
#### Post date: [December 23, 2021, 9:12pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/12 "2021-12-23T21:12:06Z")
now the are filled with numbers
---
### Author:  [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)
#### Post date: [December 23, 2021, 9:13pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/13 "2021-12-23T21:13:33Z")
I’ve cleared the lookup columns and recreated them but it still doesn’t work.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 23, 2021, 9:24pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/14 "2021-12-23T21:24:42Z")
You must be missing something, even if one value in the whole column is not a number…or is empty, it will not convert to numbers… and relation must be set to single
---
### Author:  [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)
#### Post date: [December 23, 2021, 9:34pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/15 "2021-12-23T21:34:47Z")
In your example I see several numbers in a row. In my example there is only one.
I checked all columns i tested in googlesheets with .00 and .0 all data changed.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 23, 2021, 9:36pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/16 "2021-12-23T21:36:45Z")
In my sample, i have relation set to multiple, that’s why you see that… but for your case you need single relation
---
### Author:  [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)
#### Post date: [December 23, 2021, 9:54pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/18 "2021-12-23T21:54:14Z")
Uzo is there no other way to get the data on that other sheet?
---
### Author:  [@Hans\_Op\_het\_Roodt](https://community.glideapps.com/u/Hans_Op_het_Roodt)
#### Post date: [December 23, 2021, 9:56pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/19 "2021-12-23T21:56:21Z")
I do want to thank you for all the work you’ve done, even though we’re not done yet. But I will hold on until I know the solution.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 23, 2021, 10:04pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/20 "2021-12-23T22:04:24Z")
It has to work… there is no other way to do that in glide, you can copy these columns in Google sheets…
You can send me a copy of your app to look
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 23, 2021, 10:20pm UTC](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294/21 "2021-12-23T22:20:10Z")
you can copy and analyze this sample:
> **[StructureArt's Project](https://sample11.glideapp.io/)**
[Next page](https://community.glideapps.com/t/how-can-i-perform-a-calculation-with-data-from-another-sheet/36294.md?page=2)