App: Glide I have one tab to which you can add any food you’ve eaten on a given day. 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 So I made a relation + lookup in Glide. Now you can ad…

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 Glid…

[image] 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 => ??? [imag…

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] Back in the app, filter by this “IsToday” column: [Screen Shot 2020-02-24 at 9.40.29 AM] Or you could do if it’s today, then…

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…

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?

Exactly. Not sure if you saw the previous link. posting again here 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

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 …

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. [image] Screenshot Captured with Lightshot For me t…

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.

:unicorn: 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)

Formulars only in Glide not in GSheet, need a sumif to another tab?

Ask for Help

Robert_Petitto February 26, 2020, 10:03am 16

No problem! I, too, would love to see a round() formula in the Math column. Add a feature request!

Topic		Replies	Views
Data calculate in Data editor to Gsheets Ask for Help	10	1181	June 13, 2020
How to retrieve data after duplicating and relation in Google sheets Ask for Help	18	989	January 17, 2024
Llevar columnas de glide a google sheet Ask for Help	2	358	July 2, 2022
Show data in glide sheets Ask for Help	9	350	November 3, 2021
How to make SUMIF/SUMIFS or similar function in Glide (DATA view)? Ask for Help	10	3596	April 11, 2020

Formulars only in Glide not in GSheet, need a sumif to another tab?

Related topics