# Is there a way to set column values to 'This'?
**URL:** https://community.glideapps.com/t/is-there-a-way-to-set-column-values-to-this/38199
**Category:** Ask for Help
**Created:** [February 6, 2022, 11:59pm UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-values-to-this/38199 "2022-02-06T23:59:33Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Ben\_Nicholls](https://community.glideapps.com/u/Ben_Nicholls)
#### Post date: [February 6, 2022, 11:59pm UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-values-to-this/38199/1 "2022-02-06T23:59:33Z")
Essentially My app calculates quotes based on a formula in GoogleSheets, however it can only calculate one quote at a time based on the latest quote, after a quote is completed it is saved but is unable to be calculated again as the googlesheets formula only observes the most recent quote.
Is it possible to use a button to set a column to ‘This’ quote from within an old quote? in case a client needs or wants to recalculate the quote?
your time and help is appreciated.
Ben
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 7, 2022, 12:21am UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-values-to-this/38199/2 "2022-02-07T00:21:28Z")
If you can move the logic to Glide using a math column (for example), you can use user-specific columns for this.
> **[User-specific columns](https://docs.glideapps.com/all/product/data-editor/user-specific-columns)**
Can you tell us what your formula does?
---
### Author:  [@Ben\_Nicholls](https://community.glideapps.com/u/Ben_Nicholls)
#### Post date: [February 7, 2022, 12:53am UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-values-to-this/38199/3 "2022-02-07T00:53:34Z")
The formula filters each ID from all the quotes and comes up with an average cost based on all the matches. Essentially I want to be able to set the quote it is finding matches for to ‘Quote 1’ or whatever, instead of say ‘Quote 300’
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 7, 2022, 3:06am UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-values-to-this/38199/4 "2022-02-07T03:06:43Z")
Sounds like a good case for using a relation column to link each ID to it’s matches, the use a rollup column to calculate the average. It would take the logic out of the google sheet (giving you instant real time calculations), and you wouldn’t have to figure out any weird logic to make this work with a google sheet.
---
### Author:  [@Ben\_Nicholls](https://community.glideapps.com/u/Ben_Nicholls)
#### Post date: [February 7, 2022, 6:49am UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-values-to-this/38199/5 "2022-02-07T06:49:01Z")
Thanks, I’ll look into it!