Card view, have sub-tasks reflect same status as parent

Hudson_TMR

I have a simple tracking sheet. Tasks with status's. I view this sheet in card view typically. The Status column has your standard (backlog, working, in review, closed) values as drop down lists in sheet view, enabling view by status in card view.

When there are sub tasks, I'd like for their status to change at the same time as their associated parent changes. So even if a sub task is not 'done', if the parent status changes to closed, I'd like the sub tasks to also shift their status to closed.

I've built the helper column for status to show the value of the parent for the sub tasks, so the helper column (Status Helper) has a column formula of =Parent(status@row) and that correctly shows the value in the associated parent's Status field. I can't seem to figure out how to 'force' this into the subtask's status field using the automation. The automation engine doesn't seem to want to take a formula that fills the status field.

Any thoughts or suggestions would be appreciated.

Paul Newcome

You can't use a formula in the automation, but you can set up a separate automation for each of the different statuses. Are you currently using a formula to populate the status on the parent rows?

Hudson_TMR

I am not using a formula to populate the status in the parent column. That's the one we are 'filling' by changing the bucket it's in via card view. Let me ponder the automation route for each of the status's and see if that's feasible. (I mean I know it is, but I'm not sure I care THAT much.).

Appreciate the advice.

Hudson