# Weekly Receipt Tally

**URL:** <https://community.glideapps.com/t/weekly-receipt-tally/17536>\
**Category:** Ask for Help\
**Created:** [October 24, 2020, 3:45am UTC](https://community.glideapps.com/t/weekly-receipt-tally/17536 "2020-10-24T03:45:04Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![KSpears66](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kspears66/32/15634_2.png) [@KSpears66](https://community.glideapps.com/u/KSpears66)\
**Post date:** [October 24, 2020, 3:45am UTC](https://community.glideapps.com/t/weekly-receipt-tally/17536/1 "2020-10-24T03:45:04Z")

</div>

Hi I’m building my first Glide App using the Expense Template. My real world scenario was inspired after a fire destroyed my kitchen; thankfully no harm to my family

My insurance will reimburse meals after we send them a tally of the receipts. The Expense App is ideal but within the template, I want to tally the receipt amount weekly, and send the images to the Insurance agents email address. Is that possible?

---

<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:** [October 24, 2020, 4:07am UTC](https://community.glideapps.com/t/weekly-receipt-tally/17536/2 "2020-10-24T04:07:22Z")

</div>

So you want to rollup the amount expense week by week, is that correct?

---

<div class="post-metadata">

**Author:** ![KSpears66](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kspears66/32/15634_2.png) [@KSpears66](https://community.glideapps.com/u/KSpears66)\
**Post date:** [October 24, 2020, 4:12am UTC](https://community.glideapps.com/t/weekly-receipt-tally/17536/3 "2020-10-24T04:12:41Z")

</div>

Yes. My Insurance company asked for a weekly rollup. I was hoping to invoke this by using a date range, but I’m not sure how to do that. Thanks for any suggestion.

---

<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:** [October 24, 2020, 4:20am UTC](https://community.glideapps.com/t/weekly-receipt-tally/17536/4 "2020-10-24T04:20:50Z")

</div>

Firstly, I assume you have a date for each insurance submission. I think you can use a WEEKNUM function inside the Sheet.

> **[WEEKNUM - Docs Editors Help](https://support.google.com/docs/answer/3294949?hl=en)**

Then have a supporting sheet to make a unique formula, getting all unique weeks from the original WEEKNUM you created.

Inside Glide, you make a multiple relation using the unique weeknum back to the original sheet, then use a rollup to sum the values for each week.

> **[Relation Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column)**
>
> Relate items to other items

[https://docs.glideapps.com/all/reference/data-editor/computed-columns/rollup](https://docs.glideapps.com/all/reference/data-editor/computed-columns/rollup)

---

<div class="post-metadata">

**Author:** ![KSpears66](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kspears66/32/15634_2.png) [@KSpears66](https://community.glideapps.com/u/KSpears66)\
**Post date:** [October 24, 2020, 4:23am UTC](https://community.glideapps.com/t/weekly-receipt-tally/17536/5 "2020-10-24T04:23:07Z")

</div>

ThinhDinh, thanks for the response and direction. I will give it a try and share back my progress. Again, thanks.