I don’t know if I need automation or formula or just psychiatric help. Probably a combo of all 3 at this point.
Is there any way to create an automation that will update an item’s status if it’s due date changes? My goal is to have a “delay” status column update via an automation when a baseline date changes.
I have a Current Due Date column and a Baseline Due Date column. The baseline column sets via an automation when the Current Due Date column is initially populated. I have a formula that tells me the difference between these two columns. But I can’t use that formula column to do anything with a status automation. As far as I can see, there aren’t any automations that will set a status based on a date change.
I know I can use marketplace apps to extract the formula results; but I’d really like a native solution. We previously had an AI automation; but after 6 months of working perfectly, it is now setting everything to delayed.
Anyone else tracking delayed or pushed out items? Is there something obvious I’m missing?