Obviously I've only one cat, but being totally indoors, the tray does get used all of the time.
I scoop twice a day, poos in the loo, wees in the bin, I only change it completely every 2 weeks, but do top up in between. It NEVER smells, and clumps brilliantly so you get everything out really easily.