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
Solved! Go to Solution.
Try using SWITCH() in your formula
SWITCH(
WEEKDAY(date here),
1,
[PODS].[1],
2,
[PODS].[2],
etc
)
Try using SWITCH() in your formula
SWITCH(
WEEKDAY(date here),
1,
[PODS].[1],
2,
[PODS].[2],
etc
)
Great idea… it works!!!
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |