# đ Set Column Action: Alter a DIFFERENT SHEET'S VALUES!
**URL:** https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342
**Category:** Project Showcase
**Created:** [November 13, 2020, 2:31am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342 "2020-11-13T02:31:33Z")
**Posts on this page:** 20
**Page:** 4
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 8, 2020, 8:53am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/61 "2020-12-08T08:53:22Z")
Are you talking about the template method above? It wonât have any issues I believe.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 8, 2020, 1:09pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/62 "2020-12-08T13:09:15Z")
It will be fine. All calculated glide columns, including templates and relations, are calculated on each individual device. That functionality doesnât happen on the Glide servers, so it will be a unique experience for each user.
---
### Author:  [@profechef](https://community.glideapps.com/u/profechef)
#### Post date: [December 8, 2020, 5:05pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/63 "2020-12-08T17:05:33Z")
Those are good news!
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 8, 2020, 5:17pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/64 "2020-12-08T17:17:31Z")
I cant wait until we are able to clear entire columns with the exception of their headers. That would make for some amazing options.
---
### Author:  [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)
#### Post date: [December 9, 2020, 6:21am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/65 "2020-12-09T06:21:24Z")
Whatâs your use case?
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 9, 2020, 7:37am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/66 "2020-12-09T07:37:50Z")
To clear entire columns except top row
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 9, 2020, 8:04am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/67 "2020-12-09T08:04:15Z")
So Imagine you had a contest and u used rows because u had multiple people. Contest ends now your manually clearing columns
Or a game when its game over
Or maybe a daily routine
the lists go on and on
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 9, 2020, 8:29am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/68 "2020-12-09T08:29:58Z")
With my fantasy app I do this every week, across multiple sheets.
But I have it scripted. Would be rather neat to be able to do this from within Glide.
One less reason to rely on scripts.
---
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 9, 2020, 2:09pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/69 "2020-12-09T14:09:02Z")
Yeah, I would like Glide to be able to do it but for now itâs scriptsâŚ
---
### Author:  [@sam1](https://community.glideapps.com/u/sam1)
#### Post date: [April 17, 2021, 2:45pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/70 "2021-04-17T14:45:19Z")
hi there sir,
i have a âsubtotalâ column in sheet-1 and want to show it on a âformâ which is made from sheet-2. How to do?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 17, 2021, 3:02pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/71 "2021-04-17T15:02:38Z")
Youâd need to bring it into sheet 2 somehow using a relation/lookup.
---
### Author:  [@sam1](https://community.glideapps.com/u/sam1)
#### Post date: [April 17, 2021, 5:05pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/72 "2021-04-17T17:05:10Z")
can you please tell how to make relation?
---
### Author:  [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)
#### Post date: [April 17, 2021, 5:29pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/73 "2021-04-17T17:29:45Z")
@sam1
[ ](https://www.youtube.com/watch?v=PN1xxatjmF0)
> **[Glide ⢠Quickstart](https://www.glideapps.com/docs)**
>
> Publish your first app in under 5 minutes
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 17, 2021, 5:34pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/74 "2021-04-17T17:34:45Z")
Generally speaking, you need to find or create a column of matching/linking values in each sheet. This is not necessarily the column that has the data that you want to bring over.
Then, in sheet 2, create a relation column in the Glide Data Editor in which youâll select the two column that âmatchâ. Then create a lookup column that brings the column of data that you need to access into the second sheet.
---
### Author:  [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)
#### Post date: [April 17, 2021, 8:11pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/75 "2021-04-17T20:11:48Z")
I learned a trick from @Darren_Murphy â I now put a template column in every sheet: tp-link â\> with the value
link
No actual use of the template column, bar forcing in the string.
Then I name my re-columns usually just connect tp-link columns together.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 17, 2021, 8:17pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/76 "2021-04-17T20:17:53Z")
Iâve done this before. Helpful for making generalized relations between sheets!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 18, 2021, 3:22am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/77 "2021-04-18T03:22:13Z")
> [@Mark\_Turrell](#):
>
> I learned a trick from @Darren_Murphy â I now put a template column in every sheet: tp-link â\> with the value
_every_ table?
I think you might be getting a bit carried away with this one⌠đ
---
### Author:  [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)
#### Post date: [April 18, 2021, 8:48am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/78 "2021-04-18T08:48:26Z")
almost every table!
---
### Author:  [@Glider](https://community.glideapps.com/u/Glider)
#### Post date: [April 18, 2021, 8:56am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/79 "2021-04-18T08:56:20Z")
đ đ
---
### Author:  [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)
#### Post date: [April 18, 2021, 11:53am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/80 "2021-04-18T11:53:52Z")
Been such a long time. Welcome back. Hope all things good and well @Glider
[Previous page](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342.md?page=3)
[Next page](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342.md?page=5)