Java script to replace excel formulas

[Keith_Chikumbirike]

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

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” 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 [image] 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.

[Darren_Murphy]

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:

Trash your Excel Formulas

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 Enjoy! [Glide: Replace 14 Excel Formulas with Glide Computed Columns]