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
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
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
-
- 40
- 0
- 5 days ago
-
- 79
- 0
- Mar 14
-
- 209
- 0
- Mar 8
-
- 195
- 0
- Feb 21
-
- 167
- 0
- Feb 14
-
- 225
- 0
- Feb 13
-
- 208
- 0
- Feb 11
-
- 224
- 0
- Feb 8
- see all
Recent Activities
Christian20032025 asked 5 days ago
Formula for an automation that sets due-date to ne…amandabee selected an answer Feb 24
Can I use a button to create a calendar event for …Barbora commented Feb 24
The Filters in the databases don't disappear.
...