Question

situation: a cross-cutting task with two responsible
people

I want it to be: we change the status -- the responsible person automatically changes

how can this be achieved, please help me

Answer 1

You have 2 options.

1- Use something external like Make or Zapier to automate it based on the status property. (if status = pending, set "John" in the person property)

That may let you use the person property in your Notion database.

2- Using just Notion you have to create a formula to show the person. (no people property, just text)

Something like if status = pending, show John, otherwise show Charles. Of course you will have to create the Notion formula depending on all the status states you have and all the involved persons.

Hope that helps.