# Add Rows in Sales Data Sheet coming from other sales channel

**URL:** https://community.glideapps.com/t/add-rows-in-sales-data-sheet-coming-from-other-sales-channel/12315
**Category:** Ask for Help
**Created:** [July 11, 2020, 4:09pm UTC](https://community.glideapps.com/t/add-rows-in-sales-data-sheet-coming-from-other-sales-channel/12315 "2020-07-11T16:09:18Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Axta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/axta/32/10479_2.png) [@Axta](https://community.glideapps.com/u/Axta)
#### Post date: [July 11, 2020, 4:09pm UTC](https://community.glideapps.com/t/add-rows-in-sales-data-sheet-coming-from-other-sales-channel/12315/1 "2020-07-11T16:09:18Z")

</div>

Hi,  
I have a sales app where users can buy 2 types of products: [https://coffeesub.glideapp.io/](https://coffeesub.glideapp.io/)

1. One time payment (via Glide)
2. Subscribe (I created a link to subscribe via [https://tillypay.com](https://tillypay.com) )

Problem:  
I need to combine these two sources of customers into one sheet (or can I separate these in 2 sheets?).  
I was planning on adding via Zapier the ones coming from Tilly into my App: sales tab. If I do this, will everything continue to work? (when I added a column to the Sales data sheet created by Glide it stopped updating)

 ![Screenshot 2020-07-11 at 17.26.51](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/ffe7c034a46505dd0d6c4791ed3c3620ad3780ca.png)  
 ![Screenshot 2020-07-11 at 17.43.40](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b27485a0d6bbbe6667429ec5bc173d9e5e4f6c36.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: [July 11, 2020, 4:15pm UTC](https://community.glideapps.com/t/add-rows-in-sales-data-sheet-coming-from-other-sales-channel/12315/2 "2020-07-11T16:15:34Z")

</div>

You can let the ‘App: Sales’ sheet and the sheet where you get the other channel’s info be updated separately into your Spreadsheet, then add a sheet with all unique columns from those 2 and use the right formulas to bring them together, stack them on each other.

---

<div class="post-metadata">

### Author: ![Axta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/axta/32/10479_2.png) [@Axta](https://community.glideapps.com/u/Axta)
#### Post date: [July 11, 2020, 4:31pm UTC](https://community.glideapps.com/t/add-rows-in-sales-data-sheet-coming-from-other-sales-channel/12315/3 "2020-07-11T16:31:50Z")

</div>

THANK YOU!  
But what are the rich formulas for such a case?  
Right now if I leave the ‘App: Sales’ as it is, then combine the sales data coming from Glide in ‘DYNAMIC Sales’ and ‘Subscribers’ using ={‘DYNAMIC Sales’!B2:B} which comes from ={‘App: Sales Sales’!B2:B}  
If I add data coming from another source, the ={‘App: Sales Sales’!B2:B} is not the right formula to do this

---

<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: [July 11, 2020, 5:30pm UTC](https://community.glideapps.com/t/add-rows-in-sales-data-sheet-coming-from-other-sales-channel/12315/4 "2020-07-11T17:30:25Z")

</div>

Use something like

`={‘App: Sales’!B2:B;’Subscribers’!B2:B}`