# Send Formula with Glideapps Forms

**URL:** <https://community.glideapps.com/t/send-formula-with-glideapps-forms/15444>\
**Category:** Ask for Help\
**Created:** [September 8, 2020, 8:01am UTC](https://community.glideapps.com/t/send-formula-with-glideapps-forms/15444 "2020-09-08T08:01:42Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marco72](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marco72/32/13094_2.png) [@Marco72](https://community.glideapps.com/u/Marco72)\
**Post date:** [September 8, 2020, 8:01am UTC](https://community.glideapps.com/t/send-formula-with-glideapps-forms/15444/1 "2020-09-08T08:01:42Z")

</div>

Hi All,

New to the community I had a thorough check of the forums and there is so much to take into, lots of ideas, one can really get stuck with putting more and more features in the app. One thing I was not able to figure out is how I can transfer an easy formula like this =D1_Lvl\_Points!$F$2 with a glideapps form. The following formula for the next entry would be =D2_Lvl\_Points!$F$2 and =D3\*Lvl\_Points!$F$2 and so on.

Say someone is posting terms on a freelancers project in an app and receives points for posting. Now I can easily transfer a number of days (D1, D2 or D3) and multiply with a static field (Points!$F$2) to sum up the project points one can receive. These points will than be transfered to the posters profile.

But as things stand I have to manually copy the formula =Dn\*Lvl\_Points!$F$2 to the column???

Thanks for any hints, ideas…

Rgds,  
Marco

---

<div class="post-metadata">

**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:** [September 8, 2020, 8:28am UTC](https://community.glideapps.com/t/send-formula-with-glideapps-forms/15444/2 "2020-09-08T08:28:03Z")

</div>

You can use a math column inside Glide to multiply your Day to a fixed number.

---

<div class="post-metadata">

**Author:** ![Marco72](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marco72/32/13094_2.png) [@Marco72](https://community.glideapps.com/u/Marco72)\
**Post date:** [September 8, 2020, 11:30am UTC](https://community.glideapps.com/t/send-formula-with-glideapps-forms/15444/3 "2020-09-08T11:30:24Z")

</div>

Hi, thanks for your thoughts on this. But again, user uses Glide Form to post a project, which adds a row in the sheet. Now I need that specific formula to be send with D+1 wheras D is the column. Is this possible inside the data editor? how please?

---

<div class="post-metadata">

**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:** [September 8, 2020, 11:31am UTC](https://community.glideapps.com/t/send-formula-with-glideapps-forms/15444/4 "2020-09-08T11:31:56Z")

</div>

The formula will be applied across all rows, if you don’t need to see it in the sheet then you can use my suggestion.

---

<div class="post-metadata">

**Author:** ![Marco72](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marco72/32/13094_2.png) [@Marco72](https://community.glideapps.com/u/Marco72)\
**Post date:** [September 8, 2020, 1:20pm UTC](https://community.glideapps.com/t/send-formula-with-glideapps-forms/15444/5 "2020-09-08T13:20:57Z")

</div>

Hi,

thanks thus far. Yes the maths does the job but there is no way to relate to the static which is in another tab of the sheet? Lvl\_Points!$F$2 -\> Lvl\_Points is not on the same tab.

Rgds,  
Marco

---

<div class="post-metadata">

**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:** [September 8, 2020, 1:47pm UTC](https://community.glideapps.com/t/send-formula-with-glideapps-forms/15444/6 "2020-09-08T13:47:28Z")

</div>

You can bring that over using a Single Value column, or if you don’t ever plan to change it then just pass that value straight into the formula.

As in Days \* 300.
