Summarizing Dates
How do I get my report to summarize who is here during specific dates?
Example, we have a spreadsheet that shows student names, experience start date, experience end date, quarters, department. My supervisor wants to see what students are here between the dates of July 1st - September 30th. How do I show that on a report?
So if a student is here 5/1/23-8/1/23 they would show on this report and also a student who is here 7/1/23-8/1/23 (they are both here during that time period so should show up on this report). Is there a way to do this?
Thank you!
Answers
-
Hello Taylor! Try adding the following filters:
Experience Start Date is between 7/1/23 and 9/30/23
OR
Experience End Date is between 7/1/23 and 9/30/23
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Monique Odom-Stearn
Portfolio Operations Tools Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 142 Industry Talk
- 473 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives