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 | |
29 | |
22 | |
20 | |
15 |