Days since column status changed

Platform discussions
, ,
1

Hello,
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.

Regards,
Jayda

2

Hey @jaydabreex3,

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

Screen Shot 2023-04-19 at 11.53.39 am
Screen Shot 2023-04-19 at 11.53.39 am1990×934 158 KB

This is how it would look in your board:

Screen Shot 2023-04-19 at 11.59.59 am
Screen Shot 2023-04-19 at 11.59.59 am916×378 13.2 KB

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

3

Hi,

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
4

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

1 Like