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
-
- 99
- 0
- 1 day ago
-
- 1148
- 1
- Apr 4
-
- 330
- 1
- Mar 20
-
- 373
- 0
- Mar 14
-
- 547
- 0
- Mar 8
-
- 296
- 0
- Feb 21
-
- 276
- 1
- Feb 14
-
- 368
- 0
- Feb 13
- see all
Recent Activities
joeythelemur asked 1 day ago
How can I better organize a LOT of properties?discossstick asked Apr 4
settings of font colour changed?polle answered Apr 2
Where can we send feature suggestion to Notion so …
...