I am trying make a helper column (in my calendar I have made) that will give me a number so I can assign that number to a person and they will be on duty when their number comes up. I am using parent rows so I have a level column and I only want this number to appear on the level 1 rows. I need the numbers to go up in order but finish at 12 and start again at 1. I will then use these numbers to assign to contacts off another sheet.
I would like the Duty Student Number Calc to be the numbers 1 - 12. I was trying to use the Running total formula to assist.
I hope this makes sense.... Thanks in advance!!
Help Article Resources
Check out the Formula Handbook template!