I’m looking for an automation which can change the date of the parent item when a specific subitem status is changed.
So my company is using the item as project and subitems as tasks of that project. Our goal is the date of the item is pushed by 1 week from today’s date when a specific task is done.
The only automation I found is when the status of the subitem changed push the date by X days. With this automation, any subitems’ status change will push the date.
One solution would be to add an additional subitem status column “Type”, set to “Special”. Then you would be able to use a custom automation like this: