# Run user added row of data and run against formula **URL:** \ **Category:** Ask for Help\ **Created:** [January 20, 2021, 7:56pm UTC](https://community.glideapps.com/t/run-user-added-row-of-data-and-run-against-formula/21458 "2021-01-20T19:56:46Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Nic\_Aslett](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nic_aslett/32/20117_2.png) [@Nic\_Aslett](https://community.glideapps.com/u/Nic_Aslett)\ **Post date:** [January 20, 2021, 7:56pm UTC](https://community.glideapps.com/t/run-user-added-row-of-data-and-run-against-formula/21458/1 "2021-01-20T19:56:46Z")
Hi, I am trying to do something I consider pretty basic but can’t seem to get to work. I am having a user add a row of data; name, amount, date On that same row of data, I would like a formula to run against the amount that was entered. I have attempted: Just putting in an ifblank statement with the formula into a cell Creating a table Using the arrayformula All of these attempts have produced the same problem, which is, it considers the rows as used and will not add data to them, instead it will skip past any rows with any special stuff going on and add to the bottom of the spreadsheet. If I delete the formulas, tables, etc, it puts the data at the top again - but doesn’t run against the formula… So I am not sure how to manipulate the user entered data without manually going in and adding it via the spreadsheet. Thoughts? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 20, 2021, 8:53pm UTC](https://community.glideapps.com/t/run-user-added-row-of-data-and-run-against-formula/21458/2 "2021-01-20T20:53:06Z")
Use arrayformulas instead and delete all empty rows. Also consider doing the math within glide instead of the google sheet if you need the results to only show in the app.