Column references inside []

[simone_checchin]

Hi to all,
I have this situation:
a table with these column:
pods ; 2 ; 3 ; 4 ; 5 ; 6 ; 7 ; 1
this table is referenced with another table
I don’t know if it is possible, but I’m trying…
in a formula of an action I want to create a reference to the column, corresponding to the day number.
I’ve tried this formula but it doesn’t work
[PODS].[WEEKDAY(DATE)]
in fact I want to write in the formula 2 or 3 or 4 ecc ecc instead of “weekday(date)” in order to have, for that row, the value where weekday(date) match with the column name.
Many thanks

[jacksonmihailov · Accepted solution]

simone_checchin:

[PODS].[WEEKDAY(DATE)]

Try using SWITCH() in your formula

SWITCH(
WEEKDAY(date here),
1,
[PODS].[1],
2,
[PODS].[2],
etc
)

[simone_checchin]

Great idea… it works!!!