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. 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. 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.
- 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!