# Automatic Calculation **URL:** \ **Category:** Ask for Help\ **Created:** [May 27, 2024, 1:46pm UTC](https://community.glideapps.com/t/automatic-calculation/73687 "2024-05-27T13:46:22Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Massimo\_Ridella](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/massimo_ridella/32/62138_2.png) [@Massimo\_Ridella](https://community.glideapps.com/u/Massimo_Ridella)\ **Post date:** [May 27, 2024, 1:46pm UTC](https://community.glideapps.com/t/automatic-calculation/73687/1 "2024-05-27T13:46:22Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6ecf19035c766827a62df38605954fd778248a50.jpeg) Noob here asking for help 🙂 When a new person is hired, the company HR team fills these forms that then go to a google sheet. In the sheet there are certain columns that use formulas, but when the form from glide is sent, and the row is filled, the formulas don’t work. Example: entry salary (input) tax based on contract (formula calculated cloumn) 1. Is there a way to have the columns formula work with glide forms? 2. If not, is there a way to have the glide form calculate the values based on user input? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [May 27, 2024, 2:54pm UTC](https://community.glideapps.com/t/automatic-calculation/73687/2 "2024-05-27T14:54:11Z")
> [@Massimo\_Ridella](#): > > is there a way to have the glide form calculate the values based on user input? For calculations while you’re in a form we often turn to using custom forms. Basically a bunch of user specific columns on a one row table and a button to submit them. > [@How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014): > > I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using [User Specific Columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particular… > [@Massimo\_Ridella](#): > > In the sheet there are certain columns that use formulas, but when the form from glide is sent, and the row is filled, the formulas don’t work. I’d recommend getting rid of the spreadsheet formulas. You might be able to replace it with a math column in glide or simply with the custom form. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 28, 2024, 12:26am UTC](https://community.glideapps.com/t/automatic-calculation/73687/3 "2024-05-28T00:26:20Z")
> [@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) ---
**Author:** ![Massimo\_Ridella](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/massimo_ridella/32/62138_2.png) [@Massimo\_Ridella](https://community.glideapps.com/u/Massimo_Ridella)\ **Post date:** [May 29, 2024, 12:57pm UTC](https://community.glideapps.com/t/automatic-calculation/73687/4 "2024-05-29T12:57:38Z")
Hey everyone, thank you for your help! I wanted to let you guys know that a way to solve the problem was simply to add a macro on the google sheet to perform the calculations! I did it via Apps Script ---
**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:** [May 29, 2024, 1:34pm UTC](https://community.glideapps.com/t/automatic-calculation/73687/5 "2024-05-29T13:34:18Z")
Which is totally the wrong way to do it. But hey, if it works for you that’s great 👍 ---
**Author:** ![Massimo\_Ridella](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/massimo_ridella/32/62138_2.png) [@Massimo\_Ridella](https://community.glideapps.com/u/Massimo_Ridella)\ **Post date:** [May 29, 2024, 2:35pm UTC](https://community.glideapps.com/t/automatic-calculation/73687/6 "2024-05-29T14:35:21Z")
It works fine for my case, out of curiositĂ  why would it be wrong? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [May 29, 2024, 2:44pm UTC](https://community.glideapps.com/t/automatic-calculation/73687/7 "2024-05-29T14:44:33Z")
When you introduce a Google sheet there is a long delay to sync… sometimes up to 5 min. Doing the calculations in Glide is near instant and less complicated to set up than app script. Maybe the script is working now but as your app gets larger scripts can be hard to maintain. If you show us some screenshots of what you’re currently doing we could suggest an alternative fully built on Glide.