∑ Replacement for Hyperformula

Our intern @chrisozgo has been working on a replacement for the Hyperformula column, which uses the fast-formula-parser package. That package implements a subset of the Excel formula language, so it might or might not be as useful as Hyperformula was for you, depending on your use case. Another limitation is that it only allows formulas in the “Formula” property, and not in any of the cell properties.

https://column.sh/fast-formula-parser

Please let us know if you find it useful, or if you find bugs, and hopefully we can include it in the “proper” list of code columns soon.

7 Likes

Cool! Will check it out.

Most formulas work, here’s what I noticed when I started pushing it…

  • DATEVALUE works, but not DATEDIF
  • NETWORKDAYS returns 0 irregardless of the dates entered
  • Row() returns 1…would have been cool if it returned the actual row number in the Glide Table
  • Looks like there is no UPPER even though there is a LOWER and a PROPER…oversight?

@Robert_Petitto Thanks for the feedback! I’ve attached some screenshots of DATEDIF and NETWORKDAYS working for me…perhaps your input format was wrong? Let me know if it’s an issue that still persists and I can do some additional digging.

As for the UPPER I’m working on implementing that right now! Thanks for bringing that to attention!

Does DATEDIF work if selecting a date time column? Do I need to wrap it in quotes?

@Robert_Petitto while DATEDIF it does not work for date time columns, I believe it also doesn’t work in Hyperformula, which is currently our standard for this feature. If you can get it to work using Hyperformula, that’s something we need to address immediately, if not it is more likely something we will address down the line.

Great!!

I tried with SUMIF (I didn’t know this formula was included :roll_eyes:) and it worked perfect.

Thanks for your effort @chrisozgo !

3 Likes

Could the A1, A2, A3, A4 parameter names be misleading to new users??? In a spreadsheet, that would indicate 1 column and 4 rows, whereas in glide it would be looking at 4 columns in 1 row. I’m just thinking that A1, B1, C1, D1 or something else might make a little more sense for people copying formulas directly from a spreadsheet. It might mislead them into thinking that they can specify a range of rows or separate rows instead of only the columns in the current row.

Plugins like the javascript column use parameter names that make a little more sense to me, because it uses the letter P (P1, P2, P3), which to me is just short for parameter1, parameter2, etc. That might not be as clear to users trying to port over existing formulas from their spreadsheet.

6 Likes

@Jeff_Hager We tried to make it as similar to the Hyperformula column as possible, and that’s what how the original column worked. Doesn’t mean that we shouldn’t change it, of course…

1 Like

Hola de nuevo,

I don’t know how complex can be what I am going to propose, but it will definitely give us more tools to solve some difficult cases and avoid creating more calculated columns.

What if Hyerformula’s parameters can work/read array columns and give a valid result? Please, don’t hate me @chrisozgo :innocent:

Due to we can’t work and select a data range (rows) like a spreadsheet, use an array can give us a workaround for it. Here I show a hypothetical image of this wish by using the SUMIF() formula:

Maybe, this can’t be used in all formulas, but some like SUMIF() can be very useful.

Saludos!

1 Like

This is something I have wanted for a while.

1 Like

Ya…been relying on joined list, but would love one less column

It just shipped.

5 Likes

Is there still a restricted list of possible formulas?

Yes, it’s still the same package.

Awesome. Here’s what I discovered when working with dates:

2 Likes