# Formulars only in Glide not in GSheet, need a sumif to another tab? **URL:** \ **Category:** Ask for Help\ **Created:** [February 24, 2020, 1:16pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882 "2020-02-24T13:16:08Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![pwnklr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pwnklr/32/2003_2.png) [@pwnklr](https://community.glideapps.com/u/pwnklr)\ **Post date:** [February 24, 2020, 1:16pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/1 "2020-02-24T13:16:08Z")
App: [Glide](https://go.glideapps.com/app/wHBzBTnhNJeVh0uKYS7G) I have one tab to which you can add any food you’ve eaten on a given day. 1. I can’t make the vlookups in Google Sheet because when I’d add a new item, it would be added below and the formular would not apply. [Screenshot by Lightshot](https://prnt.sc/r6wcj4) So I made a relation + lookup in Glide. Now you can add food and how much and it will calculate how many calories you’ve eaten. =\> However in another tab I need the sum of consumed calories in a day. [Screenshot by Lightshot](https://prnt.sc/r6wbjf) a) any way to make the data from Glide formulars also appear in GSheets? b) any way to make a sumif date=today then sum calories. 1. is there an option to add search functionality to the choice item? Going through hundreds of foods to find the ingredient you ate today is a bit inconvenient 🙂 Thank you so much, this is (hopefully) the last piece! ---
**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 24, 2020, 1:57pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/2 "2020-02-24T13:57:05Z")
To my knowledge, there’s no way to create GSheet columns from original Glide Data. If you need to have all the data in your sheet, the VLOOKUP can still work if you first sort the data within the formula. Something like: `=VLOOKUP(__,Sort(_____),__ ,False)` However, to do a sum by date within Glide is a bit tricky as the rollup tool doesn’t allow you to reference a second column. So, do this: 1. In a second sheet, create a column of unique dates ( `=unique(LogSheet!B2:B)`) ![Screen Shot 2020-02-24 at 8.47.07 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dcf285e2e305749739ccce76c012abbe4f3a4255.png) 2. In Glide, go to that sheet and create a multiple relation between the unique dates sheet and the log sheet: ![Screen Shot 2020-02-24 at 8.47.57 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7eec4554c603a865df4eeda940f26bb7d31c901f.png) 3. Create a rollup column that summarizes the values of Relation \> Calories by calculating the sum. ![Screen Shot 2020-02-24 at 8.43.00 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/834cf4d4a5603094c44a3efa3ac1d4502a8890c3.png) 4. You now have a tab that will sum by date dynamically. Build out this tab in your app! Bonus: in the details view of the inline list, create another inline list component with that relation column to get the items that constituted that total: ![ScreenFlow](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e6bfd2a08351ef845d28d3f521dbebde1dd6aba2.gif) ---
**Author:** ![pwnklr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pwnklr/32/2003_2.png) [@pwnklr](https://community.glideapps.com/u/pwnklr)\ **Post date:** [February 24, 2020, 2:33pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/3 "2020-02-24T14:33:18Z")
> [@Robert\_Petitto](#): > > `=unique(LogSheet!B2:B)` Ok I am officially mindblown. This is some glide/gsheet magic. One thing though: I don’t need it in a list like you have, in this case I’d only need the current day! - sum by day =\> accomplished! - give me the number for today =\> ??? > **[Screenshot](https://prnt.sc/r6xqll)** > > Captured with Lightshot Any solutions for this? ---
**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 24, 2020, 2:45pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/4 "2020-02-24T14:45:54Z")
Yep! You can run a `=Today()` formula in a new column in the “unique dates” sheet to check if date is today. If so, spit back `true`. ![Screen Shot 2020-02-24 at 9.38.30 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dd2095d70515d1c08a092f5a96f2fdd9ec5a8b56.png) Back in the app, filter by this “IsToday” column: ![Screen Shot 2020-02-24 at 9.40.29 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dce17dc69e2a716c96143cdb903db401f2d96565.png) Or you could do if it’s today, then “Today” (or anything) else blank and then filter by “is not empty”. Personal preference. Now, the only limitation is that Today() and Now() formulas don’t auto update the app, so tomorrow it will still think it’s “today” and show the totals from the previous day until a new form entry is submitted to create the new date and there by update the app. If you have a Pro app, then this is a non issue as you can have the Glide app refresh “every few minutes in the background”. @JackVaughan …another situation where a “current date/time” column would come in handy 😉 ---
**Author:** ![pwnklr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pwnklr/32/2003_2.png) [@pwnklr](https://community.glideapps.com/u/pwnklr)\ **Post date:** [February 24, 2020, 2:54pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/5 "2020-02-24T14:54:07Z")
Hm, maybe i am missing sth. the sum happens through the rollup in glide. so yes, could sorta blend out all the other days which are not today. however, I need the specific value (sum of calories) from that sheet/tab in another tab. so blending the others out to make that one appear is unfortunately not helping. out of all of them, would need to pick the one for today and get that into another tab/sheet. 🤔 ---
**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 24, 2020, 3:08pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/6 "2020-02-24T15:08:52Z")
Ok. So, are you simply wanting to take the “sum of today” and use it as value in some sort of “today dashboard”? Where is this value going and for what purpose? ---
**Author:** ![pwnklr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pwnklr/32/2003_2.png) [@pwnklr](https://community.glideapps.com/u/pwnklr)\ **Post date:** [February 24, 2020, 3:10pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/7 "2020-02-24T15:10:50Z")
Exactly. Not sure if you saw the previous link. posting again here [https://prnt.sc/r6xqll](https://prnt.sc/r6xqll) in Food log you can add all your foods in Home you should see the summary of how many cal consumed ---
**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 24, 2020, 3:19pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/8 "2020-02-24T15:19:34Z")
Ok…I think all you have to do is create a relation to the `Today()` column (seen here as "new Column) in your dashboard by creating a column (either in the spreadsheet or as a template column) where the value is persistently “true” (seen here as “TodayTrue”). So, the relation will only ever refer to “today’s data”. Then do a lookup of the sum calories (New Column 0): ![Screen Shot 2020-02-24 at 10.14.04 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3bd2c37603610f0831262fd113cb71eba8be5711.png) ---
**Author:** ![pwnklr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pwnklr/32/2003_2.png) [@pwnklr](https://community.glideapps.com/u/pwnklr)\ **Post date:** [February 24, 2020, 9:37pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/9 "2020-02-24T21:37:42Z")
Oh god, I can feel it, so close! Thank you so much @Robert_Petitto already! Ok, TodayTrue works! Just noticed that a step earlier sth doesn’t work. Specifically step 3 which you mentioned in your first answer. > **[Screenshot](https://prnt.sc/r73oi8)** > > Captured with Lightshot For me the rollup doesn’t show the option to sum up the calories from the Items eaten per day like it did for a/b/c and d/e/f for you? (even tried to lookup the calories and sum those up. Rollup doesn’t recognize that field either [https://prnt.sc/r73qq7](https://prnt.sc/r73qq7) :/) ---
**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 24, 2020, 9:44pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/10 "2020-02-24T21:44:12Z")
In that list that pops up when you go to select a sheet/column in the Rollup, scroll down and see if that relation you created is at the bottom. ---
**Author:** ![pwnklr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pwnklr/32/2003_2.png) [@pwnklr](https://community.glideapps.com/u/pwnklr)\ **Post date:** [February 24, 2020, 10:02pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/11 "2020-02-24T22:02:20Z")
🦄 And you sir just won the award for damn awesome human being! Should you ever have any nutrition related questions, let me know. I am actually a coach on the side. (now off to getting to know Parabola to source some ingredients and meals to feed into the app) ---
**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 24, 2020, 10:22pm UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/12 "2020-02-24T22:22:31Z")
I’m honored! I’ll be sure to take you up on your offer! Best of luck and don’t hesitate to reach out if you need further assistance. ---
**Author:** ![pwnklr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pwnklr/32/2003_2.png) [@pwnklr](https://community.glideapps.com/u/pwnklr)\ **Post date:** [February 26, 2020, 9:14am UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/13 "2020-02-26T09:14:14Z")
Happy to:) One more thing though came up (sorry). Since I am doing more math now in Glide vs Sheets, any way to round results? Currently getting results like “433.23423423kcal burnt” which obviously doesn’t look nice. ---
**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 26, 2020, 9:58am UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/14 "2020-02-26T09:58:32Z")
Not that I’m aware. It has been mentioned in previous posts: > [@New computed column: Math](https://community.glideapps.com/t/new-computed-column-math/1963/67): > > Unfortunately there isn’t a lot of control over the formatting of a math column. I would like the ability to round the number to a certain number of decimals. Interestingly, I don’t see a thousand separator with either the basic text or the rich text component. ---
**Author:** ![pwnklr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pwnklr/32/2003_2.png) [@pwnklr](https://community.glideapps.com/u/pwnklr)\ **Post date:** [February 26, 2020, 10:01am UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/15 "2020-02-26T10:01:02Z")
Alrighty then 🤷 Thanks anyway Robert, again! ---
**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 26, 2020, 10:03am UTC](https://community.glideapps.com/t/formulars-only-in-glide-not-in-gsheet-need-a-sumif-to-another-tab/4882/16 "2020-02-26T10:03:43Z")
No problem! I, too, would love to see a round() formula in the Math column. Add a feature request! > [@A new home for Glide Feature Requests](https://community.glideapps.com/t/a-new-home-for-glide-feature-requests/4765): > > Hey Gliders, dancer:t4blush We have a new home for feature requests! [https://features.staging.glideapp.io](https://features.staging.glideapp.io). In this app you can vote & comment on existing feature requests and add new suggestions. You can still discuss feature requests in the #feature-requests category of this forum, but these will not be voted on by other users. As always, thanks for your contributions and enthusiasm for Glide. blush