BOT Automation

[Saraappsheet]

I need to change tasks status if that showing up 14 days due (virtual clm). I have tried but it doesn't work can someone help with your experience

[Saraappsheet]

@dbaum any idea.. Actually, I need to make the automation when due date reaches 14 days the status to change to "A" to "B" in every row.. my data in one table

[dbaum]

Try scheduling a daily automation that modifies all rows whose status is A and whose due date is less than today plus 14 days.

[Saraappsheet]

I tried it, I tried daily and hourly under change clm value automation.  but it doesn't working @dbaum