# How to enable data inserted into a row which some columns have a formula
**URL:** https://community.glideapps.com/t/how-to-enable-data-inserted-into-a-row-which-some-columns-have-a-formula/68370
**Category:** Ask for Help
**Created:** [December 5, 2023, 7:00am UTC](https://community.glideapps.com/t/how-to-enable-data-inserted-into-a-row-which-some-columns-have-a-formula/68370 "2023-12-05T07:00:19Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@NADHIRAH\_HALIM](https://community.glideapps.com/u/NADHIRAH_HALIM)
#### Post date: [December 5, 2023, 7:00am UTC](https://community.glideapps.com/t/how-to-enable-data-inserted-into-a-row-which-some-columns-have-a-formula/68370/1 "2023-12-05T07:00:19Z")
Hi, I am making an application that can collect rating from user and I want to automate some columns that can total all marks and give out percentage of the rating in excel but the data inserted from user will instead go into a new row instead of inserting into the row that have formula.
Does anyone know how I can achieve in automating the calculation of the ratings?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 5, 2023, 7:09am UTC](https://community.glideapps.com/t/how-to-enable-data-inserted-into-a-row-which-some-columns-have-a-formula/68370/2 "2023-12-05T07:09:43Z")
Glide will not populate row even if they appear empty, but already have a formula in them. You should be moving your logic into Glide.
> [@star\_struck Rating Component: Display Average Star Rating](https://community.glideapps.com/t/rating-component-display-average-star-rating/58731):
>
> star_struck Star Ratings are back! The Rating component in Glide Pages allows a user to assign a numeric rating to an item by selecting stars. In this video I demonstrate how to set up your Glide tables and screens to allow users to fill out a rating/review form modify their rating afterwards see a count of total ratings per item see average star rating per item view a list of all reviews per item. [[Glide Ratings Component: Accept and Display Average Star Ratings] ](https://www.youtube.com/watch?v=CZkIcLXui10) Enjoy!
---
### Author:  [@NADHIRAH\_HALIM](https://community.glideapps.com/u/NADHIRAH_HALIM)
#### Post date: [December 5, 2023, 8:13am UTC](https://community.glideapps.com/t/how-to-enable-data-inserted-into-a-row-which-some-columns-have-a-formula/68370/3 "2023-12-05T08:13:01Z")
Thanks for the reply! This would definitely work if my max rating is 5 but my client would like the max to be 7 hence my confusion. I solved the problem just now by extracting all the value of the rating using importrange formula in excel and do the calculation in another sheet. It works but uses more storage though. I hope Glide can add a formula feature in the future. Anyway thanks again!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 5, 2023, 8:31am UTC](https://community.glideapps.com/t/how-to-enable-data-inserted-into-a-row-which-some-columns-have-a-formula/68370/4 "2023-12-05T08:31:04Z")
> [@NADHIRAH\_HALIM](#):
>
> I hope Glide can add a formula feature in the future.
Not quite sure what you mean by this.
Glide does have a “formula feature” - it’s called [Computed Columns](https://www.glideapps.com/docs/automation/computed-columns).
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 5, 2023, 12:46pm UTC](https://community.glideapps.com/t/how-to-enable-data-inserted-into-a-row-which-some-columns-have-a-formula/68370/5 "2023-12-05T12:46:22Z")
I feel like a Rollup column and a Math column would do the same thing without all of the extra work.
---
### Author:  [@NADHIRAH\_HALIM](https://community.glideapps.com/u/NADHIRAH_HALIM)
#### Post date: [December 5, 2023, 3:55pm UTC](https://community.glideapps.com/t/how-to-enable-data-inserted-into-a-row-which-some-columns-have-a-formula/68370/6 "2023-12-05T15:55:09Z")
I didnt know this. I could try in the future.
Thankyou!
---
### Author:  [@NADHIRAH\_HALIM](https://community.glideapps.com/u/NADHIRAH_HALIM)
#### Post date: [December 5, 2023, 3:55pm UTC](https://community.glideapps.com/t/how-to-enable-data-inserted-into-a-row-which-some-columns-have-a-formula/68370/7 "2023-12-05T15:55:52Z")
Yes, I think so too, I’ll try tomorrow
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [December 12, 2023, 3:56pm UTC](https://community.glideapps.com/t/how-to-enable-data-inserted-into-a-row-which-some-columns-have-a-formula/68370/8 "2023-12-12T15:56:34Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.