Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

2votes

Count the number of days from last status progress change.

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

1 Answer

0vote

polle Points94270

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.

1vote

aguscolunga commented

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?

0vote

polle commented

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.

Please log in or register to answer this question.

...

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!

Connect