Clean up / Enhance real estate contact list in Google Sheets

I have taken over an assistant position for a real estate agent. I am short on time & need someone to enhance her Contacts google sheet. We have all the info but the person before me did not keep up the spreadsheet. I have added what details are available but I don’t have the time to figure out formulas & such to make it functional. Currently there are about 198 contacts. You will be able to see the general idea of the data we collect when you view the document but in general we would like :
- The sheet to auto sort based on status of contact (with “working” being at the top). It would be nice to sort the remaining as well but “working” contacts moving automatically to the top of the list as they are added to the sheet is the priority.
- Would also like to thin out the notes with only the most current notes showing. We don’t want to erase the old notes completely - so up for whatever suggestions to make that work, if possible.

Also up to hear any other recommendations on how to enhance the contact sheet in general.

This is a one off project just to get things cleaned up so that we can begin to effectively use the document. If this is a project you feel you can do - please reach out with your pricing.

Thank you in advance!!