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
Business Process Excellence 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
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives