I am looking to “show recurring tasks” according to:
- start date
- frequency in days
For response time matters, I moved many calculations & data in the DataEditor.
I do it by:
- converting dates into “day number of the year”
- calculating “(today nb - start nb) / frequency)”
The results is shown via an “if then else” when the division returns an integer.
I could work it around with a GSheet list of integers (1 to 365) but again response time issue.
Is there a trick to identify an integer into the DataEditor?