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
-
- 457
- 0
- Apr 14
-
- 368
- 0
- Apr 12
-
- 503
- 0
- Apr 11
-
- 309
- 0
- Apr 10
-
- 309
- 0
- Apr 7
-
- 308
- 0
- Apr 6
-
- 302
- 0
- Apr 4
-
- 293
- 0
- Apr 3
- see all
Recent Activities
notionbackups answered May 22
How to print or export note or page as pdf with fi…notionbackups answered May 22
How to fix messed up decimal numbers after import …pjbdr026 asked Apr 14
How do teams use Notion for collaboration?pjbdr026 asked Apr 12
CRM System in Notionpjbdr026 asked Apr 11
Dashboard Setup
...

