# Anyone been using Hyperformula for anything interesting?

**URL:** <https://community.glideapps.com/t/anyone-been-using-hyperformula-for-anything-interesting/34201>\
**Category:** Ask for Help\
**Tags:** custom-code\
**Created:** [November 8, 2021, 12:27pm UTC](https://community.glideapps.com/t/anyone-been-using-hyperformula-for-anything-interesting/34201 "2021-11-08T12:27:59Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\
**Post date:** [November 8, 2021, 12:27pm UTC](https://community.glideapps.com/t/anyone-been-using-hyperformula-for-anything-interesting/34201/1 "2021-11-08T12:27:59Z")

</div>

I’ve used it for =ROMAN 😆 and =LEFT = RIGHT so far.

Anything else that you guys are using that we can’t do in Glide yet?!

![CleanShot 2021-11-08 at 12.25.17@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/f/4f5f755cd2b019edd9b83c12fa7760f0efc06335.png)

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [November 8, 2021, 12:37pm UTC](https://community.glideapps.com/t/anyone-been-using-hyperformula-for-anything-interesting/34201/3 "2021-11-08T12:37:18Z")

</div>

There’s a whole site where you can find a ton of formulas [HyperFormula guide | HyperFormula (v1.3.0)](https://handsontable.github.io/hyperformula/)

---

<div class="post-metadata">

**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\
**Post date:** [November 8, 2021, 12:39pm UTC](https://community.glideapps.com/t/anyone-been-using-hyperformula-for-anything-interesting/34201/4 "2021-11-08T12:39:19Z")

</div>

Yep, but what have you used it for that’s not possible in Glide and interesting?

The date functions seem to be the most useful but I’m not having much luck getting them to work, not sure why.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [November 8, 2021, 1:56pm UTC](https://community.glideapps.com/t/anyone-been-using-hyperformula-for-anything-interesting/34201/5 "2021-11-08T13:56:04Z")

</div>

I am trying to use EDATE formula but did not work. Currently I am using it in Google sheet.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [November 8, 2021, 2:40pm UTC](https://community.glideapps.com/t/anyone-been-using-hyperformula-for-anything-interesting/34201/6 "2021-11-08T14:40:52Z")

</div>

Maybe using IF AND OR so you can create more complex conditional logic without multiple if-then-else columns?

---

<div class="post-metadata">

**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\
**Post date:** [November 9, 2021, 7:42pm UTC](https://community.glideapps.com/t/anyone-been-using-hyperformula-for-anything-interesting/34201/7 "2021-11-09T19:42:14Z")

</div>

Yea, think we’re ironing out some issues with dates at the moment. Me too.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [November 10, 2021, 3:36am UTC](https://community.glideapps.com/t/anyone-been-using-hyperformula-for-anything-interesting/34201/8 "2021-11-10T03:36:57Z")

</div>

Thanks for confirming. Hopefully will be able to use it with desired results.

---

<div class="post-metadata">

**Author:** ![Gregory](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory/32/21180_2.png) [@Gregory](https://community.glideapps.com/u/Gregory)\
**Post date:** [November 18, 2021, 11:08am UTC](https://community.glideapps.com/t/anyone-been-using-hyperformula-for-anything-interesting/34201/9 "2021-11-18T11:08:12Z")

</div>

I plan to use it in my data collection app to allow users more freedom on how they want to report data (e.g. absolute or relative values), so that they do not need to do the calculations in an excel sheet (for the relative values) and then later don’t know where the data came from.
