@ThinhDinh if I understand the way is to sign in Sheets if each entry is this week, last week. Only then to make relations. I’m asking because I understand you are in favor to use glide data editor where available, other than Sheets formulas
Yeah that’s what I meant, but if you want to aggregate it using Sheets then you can use a simple Query function as well. Whatever works for you 
@ThinhDinh
I got lost over again
I created that new column in expenses table, evaluate the week by date and have one of 3 values {this week; last week; 2 weeks ago}
in totals sheets I have 3 entries - I put there “total” computed by google sheets but also used the relations and then rollup - of glide - following your recommendation. as you see values are match 
BUT - it does not shown when using text component - to show that value. without filter - it shows me last row, and with filter - on week column - nothing 
What is your screen settings for the one you’re trying to have this text on?
screen settings?
The layout with components for the screen you’re trying to have this text shown.
it is built from:
- show total so far for this week
- button to form to add new expense
- list of expenses so far for this week
You have 3 rows for this sheet right? You have to filter the sheet by the week you want to show, if I get it right.
this is what I tried. believe me
This was attached before . and again:
You are filtering that by the text component, I mean you should filter it in the “Features” settings for the whole tab.
1 Like
done. solved
many thanks
1 Like