I have a task database set-up and a formula to show if tasks are completed early, on time, or late. It's working fine for one-time tasks, but apparently not recognizing due dates that are set by recurring templates. Any ideas for how to fix this? Or procedures for asking to fix this glitch?
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
I tested it and you are correct.
If you do it by the minute, live and without waiting any second, it does not work.
You need to wait for it to work.
The template creates one now at 5:03 PM today, you set Completed at 5:05 PM today (to test) = Will Not Work.
Let it work 24 hrs, if it is created today at 5:03 PM, for sure you will not add a completed date at 5:05 PM.
So I believe that is the problem, that you are testing it as a live environment, when it is not, it needs time to work. (24 hrs or more)
Created today by template (no time means 0:00), then after 24 hrs you select an end date with no time as well.
Otherwise you will need to include time in the dates. In the template, in the completed date and in the formula, that way the exact minute can work live as you are testing.
If you are not doing it 3 minutes later to test and you are actually waiting more than 24 hours, then this can be a bug. I will keep my test running till tomorrow so the item is created and add a day later the completed date to see if the same happens.
Related questions
Without Answer
-
- 40
- 0
- 5 days ago
-
- 76
- 0
- Mar 14
-
- 208
- 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 4 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.