Help with formula for line chart?

Right now I have a formula set up to count hours for each week given certain criteria.
The count from each week is then added to the past week to get an ascending total each week to display in a line graph for a running total. How can I write this formula to count when it is the current work week only so that the chart line doesn't track across to wk52 from the current week and It doesn't have to be updated manually?
Thanks
Matt
Answers
-
Hi @mromaire
You can check if a date is this week or not by a formula like this;
=IF(WEEKNUMBER(Date@row) = WEEKNUMBER(TODAY()), 1, 0)
Please take a look at the demo sheet below.
So, assuming your {Master: Job Site Readiness Range 4} range is some date range, you can add the following criteria to your formula;
,{Master: Job Site Readiness Range 4}, WEEKNUMBER(@cell) = WEEKNUMBER(TODAY())
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 450 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!