# Show Joined List and Template Column Types back into Google Sheets

**URL:** <https://community.glideapps.com/t/show-joined-list-and-template-column-types-back-into-google-sheets/25897>\
**Category:** Ask for Help\
**Created:** [April 22, 2021, 3:47am UTC](https://community.glideapps.com/t/show-joined-list-and-template-column-types-back-into-google-sheets/25897 "2021-04-22T03:47:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![laureljt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/laureljt/32/24763_2.png) [@laureljt](https://community.glideapps.com/u/laureljt)\
**Post date:** [April 22, 2021, 3:47am UTC](https://community.glideapps.com/t/show-joined-list-and-template-column-types-back-into-google-sheets/25897/1 "2021-04-22T03:47:50Z")

</div>

I use the “Template” and “Join List” columns in Glide. I also run pivot table reports in Google Sheets on the data entered through the Glide App. The issue is that these columns don’t show as options in Google Sheets. Is there a way to display the values in these columns back to the Google Sheets workbook?

 ![Screen Shot 2021-04-21 at 11.48.06 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/01d136907e4cac8a5eaa050961c077f51c193a3e.png)

---

<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:** [April 22, 2021, 5:40am UTC](https://community.glideapps.com/t/show-joined-list-and-template-column-types-back-into-google-sheets/25897/2 "2021-04-22T05:40:07Z")

</div>

You would have to either create an action somewhere in the flow, using a set column to write those values to the Sheet, or create an equivalent formula in the Sheet.

---

<div class="post-metadata">

**Author:** ![laureljt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/laureljt/32/24763_2.png) [@laureljt](https://community.glideapps.com/u/laureljt)\
**Post date:** [April 22, 2021, 5:06pm UTC](https://community.glideapps.com/t/show-joined-list-and-template-column-types-back-into-google-sheets/25897/3 "2021-04-22T17:06:34Z")

</div>

I tried that and it worked. Thank you!

---

<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/show-joined-list-and-template-column-types-back-into-google-sheets/25897/4 "2024-01-17T16:52:33Z")

</div>