I have a database where I update the date property every time an event occurs. I want to track how many times that event has occurred so I currently have a number property next to the date one and manually update it whenever I update the date property. I was wondering if there were a formula that would automatically track that. For example, the event happens on March 12, 2021, I select that date in the date property and the formula property says 1; the event happens again on the 17th, I update the date property and the formula property automatically says 2. Any help would be appreciated
Connect
1 Answer
It is not possible, the Notion formula will use the date in the cell itself and that's it, you can't count the times you change it. Not for dates and not for anything else, everything in the formula uses the data is reading from the cell and it is not possible to be monitoring changes in them.
The only way possible is adding an extra number each time as you are doing now.
Without Answer
-
- 74
- 0
- 4 days ago
-
- 390
- 0
- Jun 11
-
- 847
- 0
- Jun 4
-
- 578
- 0
- May 19
-
- 247
- 0
- May 16
-
- 591
- 0
- Apr 29
-
- 607
- 1
- Mar 20
-
- 570
- 0
- Mar 14
- see all
Recent Activities
CATA asked 4 days ago
notion do not open in my Windows PCamandabee asked May 16
Display backlinks in a block or page?
...