Yeah, here’s some screenshots… Created the maths column: [CleanShot 2020-01-18 at 13.56.04] Using the maths column [CleanShot 2020-01-18 at 13.57.39]

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 :frowning:)

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.

I hope that formatting Math Column is near the top of Glide’s todo list.

@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 …

I don’t think the glide math column can haven’t dates. You’ll have to use a formula in the sheet. [image] Calculate and Display User's Age (from Date of Birth) Ask for Help How do I get the date of birth of a user to calculate and display the user’s age?

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.

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 s…

I hope all that formula working in Sheet. I am using the same in sheet using Array formula.

@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 …

New computed column: Math

General

Jeff_Hager April 7, 2020, 11:37am 70

I don’t think the glide math column can haven’t dates. You’ll have to use a formula in the sheet.

Topic		Replies	Views
🆕 Date-time Math General data-editor	123	14182	September 27, 2023
All New Data Editor & Computed Columns General	93	3046	November 19, 2021
Foglio con calcolo Ask for Help	54	2684	October 7, 2020
Fun with Dates Project Showcase	156	7177	April 19, 2022
March Challenge - Calculator Project Showcase	82	3113	April 10, 2021

New computed column: Math

Related topics