How to show a full duration of travel in a report, even after the start date passes?
Hello, I am having the issue when a report calendar for time off in the next 2 weeks. It only lets me choose, start date in the next 14 days or end date in the next 14 days. The issue with that is, even if someone is traveling that whole week, it clears from the report once it passes the start date. How can I fix this?
Best Answer
-
Within the report filter you can click on the "AND" to change it to an "OR". You can also create separate filter groups so that it is (for example) "A or B" and "C or D" or more likely "A and B" or "C and D".
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Are you able to provide screenshots for context?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Yes, on the calendar I am just focusing on the blue. @Paul Newcome
-
Within the report filter you can click on the "AND" to change it to an "OR". You can also create separate filter groups so that it is (for example) "A or B" and "C or D" or more likely "A and B" or "C and D".
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome okay this is helpful to know, thank you! I am still struggling to figure out what I should put in the filter to have it show upcoming travel as what is starting in the next 14 days, as well as, any duration that is currently happening during that time.
-
I actually just figured it out with doing an OR end date is within the next 14 days. Thank you @Paul Newcome !
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!