Help creating a report that can select date ranges of information.

Good afternoon everyone!

I am working on a traffic counter for a few separate locations. The counter is collecting very basic information:

Location, AM visits, PM visit and a Yes/No question.

once the form collects the data an automation then moves the input data to one of the four locations own sheet. (MA,TX, China, Japan)

These individual sheets then feed into a report that will display the collected information.


What I am trying to do is set up the report so we can view specific date ranges.

Example: I want to see how many visits MA had between M - F of a given week or a date range that covers a specific month.


Thank you for any help!

-Rob

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓

    @Coen

    When setting up your filters in the report, select your Date Column and then select the condition "is between" it will give you two date boxes to fill in for your start and end dates the filter is supposed to search between.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!