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
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
-
- 100
- 0
- 1 day ago
-
- 1149
- 1
- Apr 4
-
- 331
- 1
- Mar 20
-
- 375
- 0
- Mar 14
-
- 549
- 0
- Mar 8
-
- 298
- 0
- Feb 21
-
- 281
- 1
- Feb 14
-
- 369
- 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 …