Hi All,
I have 25 tables where School classes can choose from multiple lunch items from an enum list.
This example table is called โAngelfishโ and the class column is pre-populated from a google sheet to reflect the same value.
I have three virtual columns for each dinner selection that counts the number of orders for meat, veg or special.
Iโd like to reflect these three separate counts on a different data table called โSummaryโ:
So the expression needs to reflect the following
Meat Column Expression:
For the current row in the table โSummaryโ where the class column value matches the value of the class column in the table โAngelfishโ show the value of the virtual column โMeat Countโ from the Angelfish table.
I hope that makes sense? Thanks in advance.
J.
For example the Meat virtual column could have a formula likeโฆ
COUNT(SELECT(Dinners[KeyColumn],AND(
[Class]=[_THISROW].[Class],
[Date]=TODAY(),
[Dinner]=โMeatโ)
))
Thanks @Aleksi but how does that expression dynamically check all 25 different tables to bring dinner selection data into the rows of my sumamry table?
In other words I dont have a dinners selection table called โdinnersโ. I have 25 separate tables (From Google sheets tabs) that are called various things. (Angelfish, Dolphin, Pufferfish etc)
Thanks, J.
It sounds that you should think about your app structure a littleโฆ otherwise your formulas will be too complex. Is there any reason why do you need to have 25 separate sheets? Why donโt you add all data in one sheet?
Thanks, I though you might say that.
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |