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.
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.
Most formulas work, here’s what I noticed when I started pushing it…
DATEVALUE works, but not
0 irregardless of the dates entered
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
@Robert_Petitto Thanks for the feedback! I’ve attached some screenshots of
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?
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.
I tried with SUMIF (I didn’t know this formula was included ) and it worked perfect.
Thanks for your effort @chrisozgo !
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.
@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…
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
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.
This is something I have wanted for a while.
Ya…been relying on joined list, but would love one less column
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: