# Alert in math column
**URL:** https://community.glideapps.com/t/alert-in-math-column/24454
**Category:** Ask for Help
**Created:** [March 18, 2021, 3:24pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454 "2021-03-18T15:24:40Z")
**Posts on this page:** 14
**Page:** 1
### Author:  [@J\_Channel](https://community.glideapps.com/u/J_Channel)
#### Post date: [March 18, 2021, 3:24pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/1 "2021-03-18T15:24:40Z")
I made a math column and put a formula in it. But I get an alert.
This is a formula that works fine in spreadsheets.
What’s wrong?
STR L, RANK in the formula are the column names in the glide data sheet.
The formula is
STR \* (0.166436 \* (LV ^ (1/2)) +1) \* (0.53198 \* log (RAN K + 1) +1).
Alerts
Around “198 \* log (”: “log” is not a function.
---
### Author:  [@AymenM](https://community.glideapps.com/u/AymenM)
#### Post date: [March 18, 2021, 3:27pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/2 "2021-03-18T15:27:06Z")
Hey @J_Channel !
Welcome on board our community ! We hope that you’ll have a good time here !
For your information, please post any questions/issues that you may have with your Glide apps in the #help-how-to category, this will help us keep the community well organized. You’ll also be able to get some valuable information there ! (I’ve moved your topic for you 🙂 )
Take care !
---
### Author:  [@AymenM](https://community.glideapps.com/u/AymenM)
#### Post date: [March 18, 2021, 3:30pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/3 "2021-03-18T15:30:28Z")
@Darren_Murphy (_AKA The Script Man 🦸_) any help on that ?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 18, 2021, 3:31pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/4 "2021-03-18T15:31:48Z")
I can’t help but notice the space between the N and the K in RANK.
---
### Author:  [@George-Glide](https://community.glideapps.com/u/George-Glide)
#### Post date: [March 18, 2021, 3:41pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/5 "2021-03-18T15:41:22Z")
Also the space between log and the parenthesis. Try log(
---
### Author:  [@J\_Channel](https://community.glideapps.com/u/J_Channel)
#### Post date: [March 19, 2021, 1:04pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/6 "2021-03-19T13:04:31Z")
Thank you, everyone.
I have noticed and fixed all the space issues that you have pointed out.
But the result was the same.
i\*(0.166436\*(r^(1/2))+1)_(0.53198_log(n+1)+1)
For clarity, I’ve replaced the columns used in the formula with “i”, “r”, and “n”.
But the result is the same.
Is it possible to assign the LOG function of Glide from another column?
Why is “\*” not displayed?
---
### Author:  [@J\_Channel](https://community.glideapps.com/u/J_Channel)
#### Post date: [March 19, 2021, 1:36pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/7 "2021-03-19T13:36:38Z")
This is the screen for creating a math column.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 19, 2021, 1:39pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/8 "2021-03-19T13:39:08Z")
Log needs a second parameter, so after n+1, add a comma and 10, like this: `log(n+1,10)` and see if the final result matches the sheet.
---
### Author:  [@George-Glide](https://community.glideapps.com/u/George-Glide)
#### Post date: [March 19, 2021, 1:57pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/9 "2021-03-19T13:57:45Z")
Yeah, @Jeff_Hager beat me to it. I just found that out. Glide does not default to base 10.
LOG(numeric\_expression, base\_value)
The Glide error message is not accurate however. Engineering is aware of the bad message and will fix that issue.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 19, 2021, 1:59pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/10 "2021-03-19T13:59:12Z")
> [@J\_Channel](#):
>
> Why is “\*” not displayed?
`*` is part of the markdown language, so it’s trying to convert certain symbols into html formatting. Whenever displaying code or formulas in the forum you need to use code blocks. You can do that by highlighting your formula and clicking on the code block symbol `` above the text editor, or use a backtick ` ` `, or use four backticks on the line before and after the piece of code or formula you want to display.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 19, 2021, 2:01pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/11 "2021-03-19T14:01:49Z")
Yeah, figured out the base 10 part just the other day while working on my calculator.
---
### Author:  [@J\_Channel](https://community.glideapps.com/u/J_Channel)
#### Post date: [March 19, 2021, 3:18pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/12 "2021-03-19T15:18:32Z")
Thank you everyone.
Jeff\_Hager’s advice helped me solve my problem.＼(^-^)／
I am very grateful for the many polite replies to my poor English.
Thank you to the many geniuses who gave us this reply.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 19, 2021, 4:01pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/13 "2021-03-19T16:01:20Z")
> [@George-Glide](#):
>
> The Glide error message is not accurate however. Engineering is aware of the bad message and will fix that issue.
Any chance they can fix the bouncy cursor while they are at it? 😁
> [@Misbehaving Cursor when editing formulas in Math Columns](https://community.glideapps.com/t/misbehaving-cursor-when-editing-formulas-in-math-columns/22769):
>
> Whenever I try to edit a formula in a Math column, the cursor jumps to the end of the line with every key press. Do others see this behaviour? (Has it already been reported?) I get the same behaviour in both Firefox and Chrome, so I don’t think it’s a browser issue. Edit: it’s present in both the old and new builders
---
### Author:  [@George-Glide](https://community.glideapps.com/u/George-Glide)
#### Post date: [March 19, 2021, 7:24pm UTC](https://community.glideapps.com/t/alert-in-math-column/24454/14 "2021-03-19T19:24:54Z")
Actually yes, it has been noted and a re-fix of that cursor bounce is in the task.