[Automations]: Trigger on row changes with formula columns

[ABp]

Hey guys, you are a bit over my head with this discussion, but @Federico_Stefanato are you talking about similar functionality that I was looking for here?

Transition, or "promote" a row, and maintain linked status with new row

Hello! I would like help trying to set up some rows that represent work items in my team that uses Coda for planning. We do a lot of brain dump into rows, and loosely collect these items as “ideas,” things like “fix broken Twitter API” to things like “build new feature on website.” What I’d like to do is “transition,” or “promote” these ideas to their destination data type, be that a full on project with phases, or a one-off work item. However, I’d like to maintain a relationship with the or…

So sum up, I’d like to be able to:

1. Create a related row via a button action - ideally with the option to copy the contents of the “originating” row to the new one, but not necessarily…
2. Keep the statuses of the two rows in sync via some conditions, ie if the new row moves to “closed,” it moves the originating rows status to “resolved,” etc.

Very curious if you are thinking about similar functionality with your request, thanks!