Using Smartsheets for Scheduling
Good afternoon all,
First thank you for hopefully answering my simple question.
So basically we use Smartsheets at a basic function level in our organization. We have technicians in the field, and they get their tickets via Smartsheets. We currently give them the option to view their schedule up to 5 days in the future. However, the current method is painstakingly annoying.
We basically set individual reports to show "date is equal to 6/26", "date is equal to 6/27", etc..
We should NOT have to update this every day as days move on, lol.
I was able to figure out a function to work for a FILTER, but I can't for the life of me get it to work in a Report. Basically in a filter, you can have a "positive" and a "negative", but in a Report, you can't. So in a Filter, I can set it to "Is NOT today" AND "Is in the next 1 day, "Is NOT today" , "Is NOT in the next 1 day", "Is in the next 2 days", etc..
How can I get this to work in Report Builder so we don't have to remember to do this daily?
I tried searching on here a bit, and tried adding a TODAY() column and to make today the "negative", but that didn't work at all even for "Is in the next 1 day". The only date column we have to work with is "Svc. Date"...
Again, thank you in advance!