# New computed column: Math **URL:** \ **Category:** General\ **Created:** [November 13, 2019, 9:07pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963 "2019-11-13T21:07:22Z")\ **Posts on this page:** 20\ **Page:** 4
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [January 17, 2020, 8:48am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/61 "2020-01-17T08:48:32Z")
The Math column is added via the Data Editor view, on the left panel of the builder. Once added, you can use it with your component(s). ---
**Author:** ![pmhungdao](https://avatars.discourse-cdn.com/v4/letter/p/9f8e36/32.png) [@pmhungdao](https://community.glideapps.com/u/pmhungdao)\ **Post date:** [January 17, 2020, 9:27am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/62 "2020-01-17T09:27:27Z")
I added the Math column via Data Editor, and the result is already shown in the Data, but I cannot find that Math Column in the component list when designing my input form. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 17, 2020, 12:49pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/63 "2020-01-17T12:49:25Z")
When you add a text component, the math column isn’t in the list of columns to select from? Are you looking for some sort of component that doesn’t exist? ---
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [January 17, 2020, 1:23pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/64 "2020-01-17T13:23:12Z")
Yes, I think. The math column is not a UI component, it’s just a column where data is stored. The values contained in the Math column can then be displayed in your app using the most part of the component : basic text, rich text, choice, and so on… Math column : to store data. Components : to display data from column, math and all others from Glide and Gsheet ---
**Author:** ![chrishoward](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chrishoward/32/2545_2.png) [@chrishoward](https://community.glideapps.com/u/chrishoward)\ **Post date:** [January 18, 2020, 3:01am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/65 "2020-01-18T03:01:05Z")
Yeah, here’s some screenshots… **Created the maths column:** ![CleanShot 2020-01-18 at 13.56.04](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c29c7d7837e3d804dc7e20491b2d4307083b8471.png) **Using the maths column** ![CleanShot 2020-01-18 at 13.57.39](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7961ade079cbf57cc81f8c09dcfcc17a07b939ef.png) ---
**Author:** ![pmhungdao](https://avatars.discourse-cdn.com/v4/letter/p/9f8e36/32.png) [@pmhungdao](https://community.glideapps.com/u/pmhungdao)\ **Post date:** [January 20, 2020, 5:13am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/66 "2020-01-20T05:13:48Z")
Thanks, I found it under Text (Basic Text/Rich Text) section (previously looking for it under Edit Component). The problem now is: value is display without thousand separator (the basic text has label, but no separator, the rich text has separator, but no label ☹) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 21, 2020, 1:42am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/67 "2020-01-21T01:42:42Z")
Unfortunately there isn’t a lot of control over the formatting of a math column. I would like the ability to round the number to a certain number of decimals. Interestingly, I don’t see a thousand separator with either the basic text or the rich text component. ---
**Author:** ![chrishoward](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chrishoward/32/2545_2.png) [@chrishoward](https://community.glideapps.com/u/chrishoward)\ **Post date:** [January 21, 2020, 2:43am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/68 "2020-01-21T02:43:45Z")
I hope that formatting Math Column is near the top of Glide’s todo list. ---
**Author:** ![Mrinal\_Chakraborty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrinal_chakraborty/32/5239_2.png) [@Mrinal\_Chakraborty](https://community.glideapps.com/u/Mrinal_Chakraborty)\ **Post date:** [April 7, 2020, 11:30am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/69 "2020-04-07T11:30:22Z")
@Mark I could not find the answer how to achieve date calculations like I have date of Birth column need to store Age using today or Datediff formula of sheet, how can I achieve in calculated column. Also, while entering date of birth I want to show his Age on the screen, how to achieve that. Want to show some msg with age. Thanks in advance Mrinal Chakraborty India ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 7, 2020, 11:37am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/70 "2020-04-07T11:37:56Z")
I don’t think the glide math column can haven’t dates. You’ll have to use a formula in the sheet. > [@Calculate and Display User's Age (from Date of Birth)](https://community.glideapps.com/t/display-users-age/4049): > > How do I get the date of birth of a user to calculate and display the user’s age? ---
**Author:** ![Mrinal\_Chakraborty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrinal_chakraborty/32/5239_2.png) [@Mrinal\_Chakraborty](https://community.glideapps.com/u/Mrinal_Chakraborty)\ **Post date:** [April 7, 2020, 11:54am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/71 "2020-04-07T11:54:50Z")
Thanks for your prompt reply. Can I get answer of my next point. Is there any work around to calculate in addition screen before pressing submit button. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 7, 2020, 12:30pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/72 "2020-04-07T12:30:33Z")
There isn’t…I wish there was, though. It would be helpful. Since nothing is written to the sheet, yet, calculations can’t be made. I’ve managed to do calculations with dates when using the `TIMEVALUE()` formula. Converts to a number and then you can perform calculations with the number. There’s still a lag though, as the formulas have to calculate before they’re visible in the app. @Mark, can you add “VALUE” as an option for date formatting in addition to short, medium, and long? (or just allow calculations of dates and times?) ---
**Author:** ![Mrinal\_Chakraborty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrinal_chakraborty/32/5239_2.png) [@Mrinal\_Chakraborty](https://community.glideapps.com/u/Mrinal_Chakraborty)\ **Post date:** [April 7, 2020, 12:50pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/73 "2020-04-07T12:50:25Z")
I hope all that formula working in Sheet. I am using the same in sheet using Array formula. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [April 7, 2020, 3:01pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/74 "2020-04-07T15:01:57Z")
@Robert_Petitto Formatting is superficial - it wouldn’t let you do calculations. For example, if you format a number without decimal digits (i.e. to show it rounded to a whole number) and then use the number if a Math column, it will still use the original number’s full precision. We are aware of the need to calculate with date/times, and we’re thinking about the right ways to do that. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 7, 2020, 3:37pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/75 "2020-04-07T15:37:48Z")
@Mark Makes total sense. Thanks for the reply! ---
**Author:** ![Mrinal\_Chakraborty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrinal_chakraborty/32/5239_2.png) [@Mrinal\_Chakraborty](https://community.glideapps.com/u/Mrinal_Chakraborty)\ **Post date:** [April 7, 2020, 6:10pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/76 "2020-04-07T18:10:18Z")
Thanks ---
**Author:** ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)\ **Post date:** [April 22, 2020, 10:59am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/77 "2020-04-22T10:59:18Z")
Nice addition. Is there a way of using this to calculate the duration between a date column and today? Eg If I wanted to show the elapsed time (hours) between a task due date and now. I know how to do this in Sheets but can’t see how to do this using the Calc function. Thanks ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 22, 2020, 11:02am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/78 "2020-04-22T11:02:55Z")
I know it. Not at this time. I have several apps that would benefit from being able to calculate date/time columns in Glide. Adding durations, calculating duration, etc. Doesn’t exist yet. I put in a feature request in [https://features.staging.glideapp.io/](https://features.staging.glideapp.io/), but it hasn’t been approved yet. Keep hoping i guess! ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 16, 2020, 6:57pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/79 "2020-05-16T18:57:13Z")
@Karim I just tried your app [convertit.glideapp.io](http://convertit.glideapp.io). Thank you. Your calculator is blistering fast. I created a little creator in an app and it takes 8 seconds to display the result of the calculation. Did you encounter similar delays when setting up your calculator? ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 16, 2020, 6:59pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/80 "2020-05-16T18:59:55Z")
@Robert_Petitto Calculations on date and time might be done in your spreadsheet. Are you not not offering the features to your users because you want to avoid calculations in the spreadsheet? [Previous page](https://community.glideapps.com/t/new-computed-column-math/1963.md?page=3) [Next page](https://community.glideapps.com/t/new-computed-column-math/1963.md?page=5)