# Java script to replace excel formulas

**URL:** <https://community.glideapps.com/t/java-script-to-replace-excel-formulas/74043>\
**Category:** Ask for Help\
**Created:** [June 11, 2024, 10:11am UTC](https://community.glideapps.com/t/java-script-to-replace-excel-formulas/74043 "2024-06-11T10:11:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\
**Post date:** [June 11, 2024, 10:11am UTC](https://community.glideapps.com/t/java-script-to-replace-excel-formulas/74043/1 "2024-06-11T10:11:22Z")

</div>

Good day fellow gliders,

Is there any documentation on simple Java script to replace various common Excel formulas for those who are new to JS such as myself lol. Personaly I’m more familiar with excell/sheets formulas but im loving the idea of using JS after reading this post;

> [@SUMIFS and advanced formulas](https://community.glideapps.com/t/sumifs-and-advanced-formulas/41472/5):
>
> Hola, there is a plan C if you want to go beyond to Jeff’s suggestion: JavaScript code I know it’s not a “no code solution” but sometimes, not all can be “no code” wink Here my example: Imagine you want to have all values with Date=“2021-Q1” and “Expired=True”, your table could look like this [image] your JS code might be this, something short and able to save columns Later, we need to convert this result (text) to a numeric value using a Math column and get the Total (sum…

I didnt find much on the glide docs…  
Examples of JS to replace common excel formulas is what I had in mind. just llike in the example above. I dont mind learing a bit of JS myself

Help on this would be much appreciated.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 11, 2024, 11:45am UTC](https://community.glideapps.com/t/java-script-to-replace-excel-formulas/74043/2 "2024-06-11T11:45:02Z")

</div>

Whilst it’s true you can do a lot with JavaScript, and quite often with less columns, I would recommend first getting a good grasp and understanding of what can be done with the core set of computed columns.

The below is a very good primer:

> [@litter\_in\_bin\_sign Trash your Excel Formulas](https://community.glideapps.com/t/trash-your-excel-formulas/55788):
>
> wave Hey Gliders! By request, I created a video that explains how to replace 14 commonly used Google Sheet/Excel Formulas using Glide computed columns and other native Glide functionality. Formulas are timestamped in the description. For good measure, I also threw in how to use the Excel Formula plugin column upside_down_facepopcorn Enjoy! [[Glide: Replace 14 Excel Formulas with Glide Computed Columns] ](https://www.youtube.com/watch?v=YITKadLUKNE)