Hello ,
I am looking for help to write a formula that will check a box if certain criteria are met. I have students that are signing up for a class and they need the previous class or classes as prerequisites. for example i have class 1, class 2 , class 3 and class 4. each higher number class needs to have completed the prior. class 1 no prerequisite , class 2 check if had class 1 , class 3 check box if completed class 1 and class 2, class 4 check box if completed class 1, 2& 3. I have columns for student email and class. Any help would be greatly appreciated
