Is there a way to filter a report for a dashboard to only display the cells for today?

gwilkinson

I am working on a dashboard which displays the task schedule for my staff. What I am trying to get working is a report widget that shows additional assignments for the active day. I have the report built… But, I am struggling to filter it in a way it only shows the assignments for today. Currently it is showing the whole week. I already have columns in my main sheet with helper cells to display the day of the week and current date. Would I reference that today helper cell to help filter this down?

This is the main dashboard. The weekly schedule is on the left and would be populated with different data. The Daily Additional assignments on the right is what I am trying to get to only display TODAY'S data.

TLDR: I want my report widget to only display the assignment for TODAY not the entire week.

Is this doable?

Paul Newcome

You would need a helper column in the source sheet to pull in the current day's assignment based on the current weekday and then display this column in your report.

=INDEX(Monday@row:Friday@row, WEEKDAY(TODAY()) - 1)

Paul Newcome

You would need a helper column in the source sheet to pull in the current day's assignment based on the current weekday and then display this column in your report.

=INDEX(Monday@row:Friday@row, WEEKDAY(TODAY()) - 1)

gwilkinson

Thank you, I was finally able to wrap my head around this from a previous suggestion to do the same and got it working.

Paul Newcome

Happy to help. 👍️