Ask Questions

Connect

2votes

Count the number of days from last status progress change.

Asked
5597 Views
1 Answers
Open

I need to track the number of days that have passed from the last prop "Status" change.

by (140 points)

1 Answer

0vote

polle Points102630

You can make it work with a "Last edited time" property and a simple Notion formula.

Column 1 = Name (Default name property)
Column 2 = Status (Status property)
Column 3 = Last (Last edited time property)
Column 4 = Formula (Formula property)

Use the following in the formula property.

dateBetween(now(), prop("Last"), "days")

This will show you the days since the last edited time as you need.

by (103k points)

1vote

commented Jul 11, 2022

Great, but if I have many columns and different status for the same item - which would be the formula to register/track each status changed?

by (140 points)

0vote

commented Jul 11, 2022

The structure you are trying to build needs to be improved or changed then, because a single item can't have multiple statuses.

Please share in a new question what you are trying to build to see what may be a better approach, because for counting the last edit, the above is the way to do it.

by (103k points)
What if I change something else than the "status"?
asked Apr 4, 2023 by (130 points)

Please log in or register to answer this question.

Related questions

Without Answer

Recent Activities

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Tags

Connect