Days since column status changed

I would like to create a column showing how many days since a specific column changed, I saw there is the last updated automation, but that is for the entire board. I have looked through the community and can’t seem to find how to do this.

For example, I have a status column with multiple different options, and next to it I would like the column to show not the date, but how many days since that specific column changed so that I don’t have to go into the activity log to find this information every time.


Hey @jaydabreex3,

It sounds like this app might be the solution for you!

This is how it would look in your board:

Is this along the lines of what you’re looking for?


Create a automation When column changes set date to today then based on the date add this formula DAYS(FORMAT_DATE(TODAY(),"YYYY-MM-DD"), {Date}).

Hope this helps

1 Like

Thank you! This worked for what i’m trying to do I appreciate it :slight_smile:

1 Like