How to show a full duration of travel in a report, even after the start date passes?

Alicia D
Alicia D ✭✭✭✭
edited 02/15/24 in Formulas and Functions

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?

Tags:

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!