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 …

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 …

@Darren_Murphy (AKA The Script Man :superhero:) any help on that ?

I can’t help but notice the space between the N and the K in RANK.

Also the space between log and the parenthesis. Try log(

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.53198log(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 t…

This is the screen for creating a math column. [スクリーンショット 2021-03-19 22.32.48]

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.

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.

[image] 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 co…

Yeah, figured out the base 10 part just the other day while working on my calculator.

Alert in math column

Ask for Help

Darren_Murphy March 19, 2021, 4:01pm 13

Any chance they can fix the bouncy cursor while they are at it?

Topic		Replies	Views
Addin custom math functions that take parameters to a Glide column Ask for Help	7	434	January 31, 2021
Need help with formula Ask for Help	7	231	January 26, 2024
New computed column: Math General	96	6351	November 12, 2021
Math column problem Ask for Help	3	178	January 19, 2024
How can I 1+2 on glide Ask for Help	3	25	May 24, 2025

Alert in math column

Related topics