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.
@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!
@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.
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.
@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…
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: