I need to track the number of days that have passed from the last prop "Status" change.
Connect
1 Answer
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.
Related questions
- Counting the number of days in a date range based on the year (how to split day between 2023 and 2024)
- How to count out of date tasks from another page table?
- Hi ! I would like to track to time that the blocks takes to change status
- What if I change something else than the "status"?
- What is a formula to change the status using a checkbox?
Without Answer
-
- 116
- 0
- Oct 3
-
- 301
- 0
- Aug 12
-
- 348
- 0
- Aug 7
-
- 457
- 0
- Jul 17
-
- 1533
- 0
- Apr 14
-
- 1048
- 0
- Apr 10
-
- 1067
- 0
- Apr 7
-
- 1018
- 0
- Apr 6
- see all
Recent Activities
freelancerops answered 7 hours ago
How can I update a related page when an action is …freelancerops answered 7 hours ago
Looking to create a proposal w/lists that automati…freelancerops answered 7 hours ago
How can I calculate minutes to add total hours (or…freelancerops answered 10 hours ago
How Can I Use Notion to Organize a Busy Work Workf…freelancerops answered 10 hours ago
How can I filter rollups to show only the most rec…
...

