"Filter" by Hour and Minute in addition to day(s)
Hello Smartsheet Community!
I have a question. We are setting up a dashboard to display who is on call for specific regions. For some of the regions their on call is easy as it is always Midnight to Midnight but for other they weirder shift times (and people sometimes work "half shifts").
I have my reports for each region set up to display only entries where the start date or end date are today but the division it's for wants them to only show who is actively on call (it's for an emergency service and they want to make sure they there's no confusion even though I have columns for "On-Call Until/After).
So, is there a way to set up a filter that can dynamically reference the current time and check it against those columns? If not a filter then is there a formula/function where I could set it to say "if (date)time is after start and before end, display true"? Or a way to stack formulas within the TODAY() to do so?
Help Article Resources
Check out the Formula Handbook template!