# 🍥 Rollups! **URL:** \ **Category:** General\ **Created:** [February 11, 2020, 8:10pm UTC](https://community.glideapps.com/t/rollups/4509 "2020-02-11T20:10:18Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![tru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tru/32/2108_2.png) [@tru](https://community.glideapps.com/u/tru)\ **Post date:** [February 11, 2020, 8:10pm UTC](https://community.glideapps.com/t/rollups/4509/1 "2020-02-11T20:10:18Z")
Now you can do a computation across a column in a relation or a sheet! ![Screen Shot 2020-02-11 at 12.09.00 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/73cb211ffc35d0ecaa591394c3e650be4aab5f02.png) Currently we support Earliest & Latest for date type columns, Sum & Average & Min & Max for number columns, All True & Some True for boolean columns, and then Count for any column type! See how I used a rollup to calculate what recipes I can make with the Ingredients I own here: [https://food-template.glideapp.io/](https://food-template.glideapp.io/) Feel free to share any interesting ways you’re using rollups and let me know if there’s any bugs you find! 🥳 ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [February 11, 2020, 8:14pm UTC](https://community.glideapps.com/t/rollups/4509/2 "2020-02-11T20:14:26Z")
I made an [Expense Splitter](https://go.glideapps.com/app/expense-splitter-template): ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/cba07474d324de15af80a69cec74fb957b2ca58a.jpeg) ---
**Author:** ![Dan\_Liebeschutz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_liebeschutz/32/3393_2.png) [@Dan\_Liebeschutz](https://community.glideapps.com/u/Dan_Liebeschutz)\ **Post date:** [February 11, 2020, 8:40pm UTC](https://community.glideapps.com/t/rollups/4509/3 "2020-02-11T20:40:15Z")
That is great! Exactly what I needed 🙂 ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [February 11, 2020, 9:59pm UTC](https://community.glideapps.com/t/rollups/4509/4 "2020-02-11T21:59:41Z")
🔥 ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 12, 2020, 12:58am UTC](https://community.glideapps.com/t/rollups/4509/5 "2020-02-12T00:58:03Z")
Hi @tru! How do you envision users using “some true” vs “true” (that’s a lot of tru/true)? Also, would LOVE the ability to filter the Rollup by another column as well (eg count all items in a column that match true in another column or sum all items that match a users email address in another column) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 12, 2020, 1:42am UTC](https://community.glideapps.com/t/rollups/4509/6 "2020-02-12T01:42:46Z")
I think you might be able to filter the Rollup using a relation. For example set up a relation using email and it will count all the related rows with that email. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 12, 2020, 4:45pm UTC](https://community.glideapps.com/t/rollups/4509/7 "2020-02-12T16:45:09Z")
Just gotta tell you, @Jeff_Hager, that your template/relation combo trick is FANTASTIC. It takes longer than just writing a VLOOKUP formula, but if it can decrease/eliminate lag altogether, then it’s obviously worth it. I’ve already used it successfully a couple of times in my Inventory app…haven’t tested it out yet, but I expect good things. You’re the best. ---
**Author:** ![Alex\_Calandrino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex_calandrino/32/335_2.png) [@Alex\_Calandrino](https://community.glideapps.com/u/Alex_Calandrino)\ **Post date:** [February 12, 2020, 8:57pm UTC](https://community.glideapps.com/t/rollups/4509/8 "2020-02-12T20:57:32Z")
How to format the result in currency format? ![Anotação 2020-02-12 175655](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a3e2b8844c21866c2023461e31e2cd0e414dd7f9.jpeg) ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [February 12, 2020, 9:01pm UTC](https://community.glideapps.com/t/rollups/4509/9 "2020-02-12T21:01:06Z")
We are working on that. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 13, 2020, 8:09pm UTC](https://community.glideapps.com/t/rollups/4509/10 "2020-02-13T20:09:35Z")
Temporarily, you could probably create a template column to join the Currency symbol with the calculated value. ---
**Author:** ![Alex\_Calandrino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex_calandrino/32/335_2.png) [@Alex\_Calandrino](https://community.glideapps.com/u/Alex_Calandrino)\ **Post date:** [February 15, 2020, 4:22pm UTC](https://community.glideapps.com/t/rollups/4509/11 "2020-02-15T16:22:03Z")
This has already been done, as shown in the image, the problem is the cents ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 15, 2020, 4:25pm UTC](https://community.glideapps.com/t/rollups/4509/12 "2020-02-15T16:25:13Z")
Got it. Yeah I’d like to see some sort of formatting option for number columns. ---
**Author:** ![RedHeadKev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/redheadkev/32/2821_2.png) [@RedHeadKev](https://community.glideapps.com/u/RedHeadKev)\ **Post date:** [February 16, 2020, 1:15am UTC](https://community.glideapps.com/t/rollups/4509/13 "2020-02-16T01:15:26Z")
Can the formatting be done in the Spreadsheet first? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 16, 2020, 1:47am UTC](https://community.glideapps.com/t/rollups/4509/14 "2020-02-16T01:47:46Z")
It sure can, but there might be a slight delay for the update to make it back to the app compared to instant results. ---
**Author:** ![jesschrist](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jesschrist/32/86_2.png) [@jesschrist](https://community.glideapps.com/u/jesschrist)\ **Post date:** [March 4, 2020, 10:22pm UTC](https://community.glideapps.com/t/rollups/4509/15 "2020-03-04T22:22:01Z")
Format the entire column in the sheet in NUMBERS after you have at least one submission in the sheet.