I have tried different things and cannot get this to work.
I have thousands of leads that need to change ownership. Going forward, I can import new leads with the proper ownership... it is the ones that I initially imported that need to be fixed.
When doing a filtered search I can see all the records I need to change. Problem is that doing a mass update only does 100 records at a time. No way I can go through 22,000 records to get this done.
I tried reports but that only allows me to export results as an excel spreadsheet.
I tried using a plugin for excel from www.devart.com that works with the Zoho database, but that didn't allow me to change ownership.
I even tried the Workflow Rules but kind of confused on how I can just get that to work properly.
Any help with this would be greatly appreciated.