dashboard feature to show what jobs are due today

This is something I have spent hours trying to figure out. my company has customer service reps and sales people that both want to see jobs (tickets) due today or due tomorrow.

If my sheet has ticket | date | equipment | salesrep | status, i want to create a dashboard that has tickets for today, equipment for today and or even better, tickets due today for sales rep JOHN.

just a pointer in the right direction would help. I have already created matrix and summary that shows number of tickets due today, tomorrow etc. The calendar view is close to what I need but I dont want to share the sheet with sales, just a matrix.

any help appreciated



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!