It was on my radar but for some reason I didnt actually try it. Thanks for mentioning it I will take a look.
It should solve all your problems. It just has a fairly steep learning curve, but once you get to know it, you'll love it.
It's a combination of a spreadsheet and database. You have 1 'base'. Everything in a base is linkable. You can create as many bases as you want, but you can't link between bases.
Each base has tables, which are like spreadsheets. You can add as much data as you want there.
Then within each table, you have views to the left, where you can view as tables, kanbans or also calendar, gallery, timeline and list, but I don't use those.
You can group by anything you want. Sort, filter..
Then you can link between tables, so for example..
You have a clients table and a jobs table.
You can link them, so you can add 1 or more jobs to a client, and 1 client to a job, then in a job card you can click the client to bring up the client card.
You might have a team table, then you add team members to the job.
You can get really creative with it to setup the perfect structure.
And you have lots of advanced features, way beyond something like monday, where you have formulas, or something called "rollups".
Rollups are when you've linked to another table, so in your clients table, you've linked to jobs, so you could create a rollup that shows stats like how many jobs are in pending stats, how many are complete, how many are new.
Any sort of aggregated data/calculation.
Then you have automations. You could set it up so when a staff member changes a status from "working on", to "problem" it sends a message on slack.
Or you could set it to change the status from New to Ready when you assign staff members to a job. Anything you like.
You can also create views and then hide sensitive data and create a shareable view link for clients.