Hello,
Handsontable provides a way to calculate values using formulas as pseudo code
Instead of using “=IF(E57>0,E57/365,0)” i want to use formula as “=IF(ITACVD>0,ITACVD/365,0)”.
Is there any way to convert formulas from column to name?
Instead of E57 need to show TACVD in formula
I think that in this case you can use named expressions. Here’s a guide for this:
https://hyperformula.handsontable.com/guide/named-expressions.html#examples
Let me know if that’s what you needed.
I need to show this one “=IF(ITACVD>0,ITACVD/365,0)” when edit formula field.
In named expressions, i can not use this expression as name.
I see, thank you. I will check if it can be achieved in different way and I’ll get back to you soon.
Sure. Thank you.
There was a missing part in my previous example. Actually, you can use expression as a name. Please look at this demo:
That’s great. I’m closing this topic then.