Forum Discussion
Counter of recurring earned points by children....
AyS0908 Please see the sample worbkook for the suggested solution.
The teacher/parents will make the choice of Year in cell A1, Month in cell C1 and current day in cell E1 by using the dropdown.
Points of the day = points of the selected day in cell E1 = displayed in cell F1
Accumulated points = total points of the selected day + accumulated points of recurring tasks up to the selected day = displayed in cell G1
A positive comment will be displayed in cell H1 if the student achieves a certain points for the selected day.
Once you are happy with the layout, I recommend to lock the sheet and only leave the cells where the student has to choose Validation and Date of Validation to be editable so that nobody would mess up with your formulas/design.