Iโve been using the following formula but suddenly the slice doesnโt return anythingโฆ
WEEKNUM([Day])=WEEKNUM(TODAY())-1
My template has no records because of this.
Any ideas??
Thank you.
Solved! Go to Solution.
I would guess there are no values of the Day column that occur last week.
My spreadsheet has data for last week. Screen shot below.
Use instead:
(EOWEEK([Day]) = (EOWEEK(TODAY()) - 7))
Youโre very welcome.
Can you give a screenshot from your sheet?
WEEKNUM(TODAY()) - 1
gives you Zero (0). However,
WEEKNUM([Day])
is 53. Thatโs why you canโt see any records.
Is there a workaround??
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |