I want to make an automation about a status column, triggered by a date based on last update.
Basically, 7 days after last update, I need an automation which will change the status of one of my columns. The problem is the last update format is not considered as a date column, so I can’t select my last column update when I want to set up my automation :
Hi @Ayn - you are correct that you cannot utilize the last updated column within these types of automations. If there are specific columns you want to monitor and trigger this off of you could setup automations such as “when column changes set date to today and push date by 7 days”. Then use your above automation to set the status.