Marketing agency beyond frustrated with automations

Hey guys I’m new here, so you may have heard this all before, but I need help with Coda.

I’ve been using it for our business for over a year now. When I first started, I thought I would be able to setup some pretty advanced automations and streamline our processes.

But nope.

I need your guys help and suggestions because I can’t even figure out how to setup the basic notification automation feature.

So let me break down the scenario:

  1. We onboard a new client and create a row for their project

  2. I assign team members, add notes, and include links to our other software.

  3. I then change the status column to the “ready to start” chip for that row

  4. I want the team member assigned to that row to be notified when the project status changes from “not ready” to “ready to start”

I’ve spent too many hours trying to figure out the basic automation feature and I can’t figure it out. Also can’t find anybody I can hire that knows how to do this

Help! Is it even worth continuing with coda if it will never pay off like I thought it would.

How can I build advanced functions if the basic automation notification feature is impossible to figure out.

Help me