Hi, I’m trying to find a solution for being able to automatically change the status of an item that is in the group “waiting for content” to the status of “cancelled” on the condition that the item has been sitting in the “waiting for content” group for a period of 10 days.
Hey @Design - you can create a new Date column to manage this (lets call it “Set to Cancelled”). You can then use a series of automation to manage this:
When item is moved to group [waiting for content] set “Set to Cancelled” to today and Push “Set to Cancelled” by 10 days
When item is created and only if item is in group [waiting for content] set “Set to Cancelled” to today and Push “Set to Cancelled” by 10 days
When “Set to Cancelled” arrives, and only if item is in group [waiting for content] set status to Cancelled