# How to link aggregate data from one work sheet as a column in another worksheet?

**URL:** <https://community.glideapps.com/t/how-to-link-aggregate-data-from-one-work-sheet-as-a-column-in-another-worksheet/26439>\
**Category:** Ask for Help\
**Created:** [May 5, 2021, 11:17am UTC](https://community.glideapps.com/t/how-to-link-aggregate-data-from-one-work-sheet-as-a-column-in-another-worksheet/26439 "2021-05-05T11:17:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![anukin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anukin/32/15776_2.png) [@anukin](https://community.glideapps.com/u/anukin)\
**Post date:** [May 5, 2021, 11:17am UTC](https://community.glideapps.com/t/how-to-link-aggregate-data-from-one-work-sheet-as-a-column-in-another-worksheet/26439/1 "2021-05-05T11:17:13Z")

</div>

So I have two sheets one which covers services and then another with people who are validating that these services are valid.

For example:  
Service A with a column validated by in services table.  
Multiple entries with service A and validated by exists in validators table

User Flow  
A user can add any services to the services table.  
Any user can click on validate column of service and fill in his name and then the validators table will be filled with the service name and name of a validator.

What I want is to aggregate the values in `validated_by` in the validators table and bring them to services table. Also, I want to check the number of `validated_by` aggregate and set another value as verified=true based on a condition that sum(`validated_by`) \> 5.

I cannot find anyway to do this after extensive google search. I searched for `aggregate value in worksheet to another worksheet` etc.

Any help is appreciated 🙂

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 5, 2021, 11:41am UTC](https://community.glideapps.com/t/how-to-link-aggregate-data-from-one-work-sheet-as-a-column-in-another-worksheet/26439/2 "2021-05-05T11:41:47Z")

</div>

You don’t need Google formulas for this, you can do it with Glide computed columns.  
You’ll just need to create a [multi-relation](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column#multiple-relations) between the two sheets, and then you can get your counts and  
(sums) aggregates using [Rollup](https://docs.glideapps.com/all/reference/data-editor/computed-columns/rollup) columns.

---

<div class="post-metadata">

**Author:** ![anukin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anukin/32/15776_2.png) [@anukin](https://community.glideapps.com/u/anukin)\
**Post date:** [May 5, 2021, 8:31pm UTC](https://community.glideapps.com/t/how-to-link-aggregate-data-from-one-work-sheet-as-a-column-in-another-worksheet/26439/3 "2021-05-05T20:31:59Z")

</div>

Thanks this worked ❤

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/how-to-link-aggregate-data-from-one-work-sheet-as-a-column-in-another-worksheet/26439/4 "2024-01-17T16:52:20Z")

</div>