Sign in to join the conversation:
I have charts to show progress by week to date, month to date, and year to date. I reference another sheet to indicate the date range for each chart. Is there a way to automate my reference sheet so I don't have to change the dates manually?
if you want to show the current period I recommend using a helper column then using that as criteria in your formulas
if(weeknumber([date ref]@row) = weeknumber(today()),1,if(month([date ref]@row)= month(today()),2,if(year([date ref]@row) = year(today()),3)))
then in your criteria you can use something like
current year
[Helper C]1 >0
Current month
[Helper C]1 < 3
Current Week
[Helper C]1 = 1
This is also nice for filtering data. I often use a next period helper column to quickly navigate my larger sheets.
Thanks!
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
