Hi, I come back with my pending issue of “recurring challenges” for kids at school (for which I had fruitful exchanges with @Robert_Petitto @ThinhDinh @Jeff_Hager).
The objective: display daily a calendar with the challenge of the day, per kid
(requires several columns to be “user specific”).
The approach: upfront, the user sets it up by:
1/ selecting the challenges he is interested in >> done in DataEditor with a “check” | “user specific” column
2/ defining the recurrence per challenge (ex. each 1, 2, 3 days) >> done in DataEditor with a “nb” | “user specific” column
3/ setting a start-date >> done in DataEditor with a “date” | “user specific” column
4/ calculate if the challenge is to be displayed according to the frequency & starting date >> I ‘found’ a formula for GSheet, but it’s much beyond my newbie skills to build it in DataEditor, which is required since its again a “user specific” date: (=IF(C6>TODAY();0;IF(MOD(TODAY()-C6;B6)=0;1;0)))
Summarized illustration: https://docs.google.com/spreadsheets/d/1sf8QcoBf9iK0sVSkWJbjx3FAECj1-pwlAT7soWYmRq4/edit?usp=sharing
Many thanks in advance if you know how to write this formula in Glide!
Cheers